Link Subform to Subform

[Kat via AccessMonster.com]

Hi there

I was wondering if someone could help:

I have an unbound form with 2 subforms. On the unbound form, i have an
unbound combo box (cmbo_name) that displays a list of names. When a name is
selected, the person's details are shown on the first subform (works
perfectly) what im having trouble doing is linking the first subform to the
other subform so when a selection is made in subform1, it's details should
appear in subform 2. Does anyone know how this can be done??

 

[strive4peace]

Hi Kat,

try this:

in the LinkMasterFields for the second subform:

subform1_controlname.form.controlname

each time the control in subform1 changes, subform2 will need to be
requeried

from subform1:

me.parent.subform2_controlname.requery

you should have this on the subform1 Current event as well as the
AfterUpdate event(s) of the controls that are being used

Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*