Subforms linked to subforms

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MChrist - 27 Dec 2005 23:33 GMT

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

Reply to this Message

John Vinson - 28 Dec 2005 01:30 GMT

>I'm having trouble getting my form that has two subforms in it to stay linked.
>
[quoted text clipped - 6 lines]
>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]

Reply to this Message

MChrist - 28 Dec 2005 03:14 GMT

Thanks John,

That seemed to do the trick.

Have a Happy Holiday.

Mark

> >I'm having trouble getting my form that has two subforms in it to stay linked.
> >
[quoted text clipped - 17 lines]
>
> John W. Vinson[MVP]

Reply to this Message