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.SourceOb ject = "subF2"
Save your time syntax was not the problem. MS was just helping me out tooooooooo much.
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.SourceOb
Save your time syntax was not the problem. MS was just helping me out tooooooooo much.
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)
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)
ASKER
Thanks for the tip. You get the 100 points.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.