?
Solved

MS Access SourceObject

Posted on 2006-06-29
5
Medium Priority
?
1,403 Views
Last Modified: 2008-01-09
This is information that I found out after beating my head for 4+ Hrs. It may help someone else.

I use subforms a lot. In the past if I wanted to use multiple subforms in the same screen area I would use Hide/Visible to get this done. I decided to change the SourceObject of a general subform to make the design form easyer to work with. My first form worked fine and it got me to try it again.

On my second form I did the subform but no records or one record were being displayed after I executed the SourceObject. If I ran the subform all by it's self all the data showed up. I made sure all filters were turned off, but all the data would not show up. I checked the subform info on the parent form and noticed that "ID" was showing up in both the "Link master/child" fields. I set them to "Empty" with VBA code after using the SourceObject but the data did not display. I found that the RecordSource data in both the main form and the subForm had a field named "ID". No mater what I did MS was setting up the Link. I could make the Parent form unbounded or change the field name to be different. I changed the field names and all works well.

I tried all kinds on VBA code syntax.
     Me.Subx1.SourceObject = "subF2"
     Me!Subx1.SourceObject = "subF2"
     Forms!form1!Subx1.SourceObject = "subF2"
Save your time syntax was not the problem. MS was just helping me out tooooooooo much.
0
Comment
Question by:georgefanno
  • 2
4 Comments
 
LVL 66

Expert Comment

by:Jim Horn
ID: 17013216
Is this a question?
0
 
LVL 54

Expert Comment

by:nico5038
ID: 17013636
This "problem" is cause by the subform wizard, but you can prevent a link to a subform by selecting "None" when the wizard asks you for linking fields.

Personally I use a tab control in your situation to have all subforms on the same mainform and just show the needed subform page and hide the buttons so the users don't even know there's a tab control.

Nic;o)
0
 

Author Comment

by:georgefanno
ID: 17020197
Thanks for the tip. You get the 100 points.
0
 
LVL 54

Accepted Solution

by:
nico5038 earned 400 total points
ID: 17020824
Glad to see I learned you something new :-)

Success with your application !

Nic;o)
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
A quick solution showing how to control and open a POS Cash Register Drawer using VBA with MS Access.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Hi, this video explains a free download that you can incorporate into your Access databases, or use stand-alone for contact management. Contacts -- Names, Addresses, Phone Numbers, eMail Addresses, Websites, Lists, Projects, Notes, Attachments…

568 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question