Subforms linked to subforms

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm having trouble getting my form that has two subforms in it to stay linked.

The first subform is linked to the main form, and is working fine. The
second subform is linked to the first subform with the Link Master Field set
to:

forms!fProspects!sfHMDA2!HMDA_ID

Is this not the correct syntax to link to the subform called sfHMDA2 on the
main form fProspects?

Is it necessary to place a Requery on the On_Current event of the first
subform to requery the second subform when changing records?

TIA

Mark
 
I'm having trouble getting my form that has two subforms in it to stay linked.

The first subform is linked to the main form, and is working fine. The
second subform is linked to the first subform with the Link Master Field set
to:

forms!fProspects!sfHMDA2!HMDA_ID

Is this not the correct syntax to link to the subform called sfHMDA2 on the
main form fProspects?
Click to expand...

It should work, though I'd usually be explicit:

forms!fProspects!sfHMDA2.Form!HMDA_ID
Is it necessary to place a Requery on the On_Current event of the first
subform to requery the second subform when changing records?
Click to expand...

Yes, it is.

John W. Vinson[MVP]
 
Back
Top