Subforms linked to subforms

[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

 

[John Vinson]

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?

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?

Yes, it is.

John W. Vinson[MVP]

 

[Guest]

Thanks John,

That seemed to do the trick.

Have a Happy Holiday.

Mark