Link contents of SubFormB to contents of SubFormA

[Mr Wonderful]

I have a main form with 2 sub-forms
Contents of SubFormA are based on the MainForm
Even though SubFormB is also on the MainForm I need it's contents to link to SubFormA not the MainForm
i.e.
MainForm
SubFormA links up to MainForm
SubFormB links up to SubFormA

 

[dhookom]

I generally add an invisible text box on the main form named txtMasterField. Then I add code to the On Current event of the SubFormA like:

On error resume next
Me.Parent.txtMasterField = Me.LinkFieldName

Then just set the Link Master Child of the SubFormB to txtMasterField and ChildFieldName.

If you can't figure this out, you should come back with some field names.

Duane
Hook'D on Access
MS Access MVP

 

[Mr Wonderful]

Worked like a charm.
Thanks