Opening Form To a Record Inside a Target SubForm

[RichardAnderson]

Hello folks,

Here is the situations....

frmMainProgram has 2 subforms called SunMain and SubDetails. Inside SubMain is a list of records. When one is selected(clicked), I want another form to open directly to that record inside SubDetails.

This is the code I have... It open to the right record, but I just cannot figure out how to make it open inside my target subform of SubDetails.

DoCmd.OpenForm "frmProduction_Schedule_Edit", , , "[BuildID]=" & [BuildID]

[RuralGuy]

I would use an invisible TextBox on frmMainProgram as the LinkMasterFields of the SubDetails form and point the ControlSource of the TextBox to the "BuildID" of the current record of the SubMain form. No magical coding required as Access will do all of the work for you.

[RichardAnderson]

Thanks for the reply Rural...

I am trying your suggestion. I put a hidden txtbox on frmMainProgram and made the control source of it .

=[SubMain].[Form]![BuildID]

But when I go to set the preference for Link Master Fields on the subform SubDetails, I get a msgbox stating "Can't build a link between unbound forms.
The Control source of SubDetails in frmProduction_Schedule_Edit so it shouldnt be unbound.

[RichardAnderson]

I figured it out.... I needed a control source for frmMainProgram.

Thank you for your help .... youre awesome.

[RuralGuy]

Outstanding! Glad we could help.

[wes9659]

So what did the final code look like? I think I have a similar problem with my forms