Link to home
Start Free TrialLog in
Avatar of georgefanno
georgefanno

asked on

MS Access SourceObject

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.
Avatar of Jim Horn
Jim Horn
Flag of United States of America image

Is this a question?
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)
Avatar of georgefanno
georgefanno

ASKER

Thanks for the tip. You get the 100 points.
ASKER CERTIFIED SOLUTION
Avatar of nico5038
nico5038
Flag of Netherlands image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial