Combo box Value list to subform

S

sap4ora

Hello

How to get a subform to show details based on a combo box value list on the
main form?


Regards,
 
J

John Vinson

Hello

How to get a subform to show details based on a combo box value list on the
main form?


Regards,
Click to expand...

Set the Master Link Field property of the subform control to the name
of the combo box, and the child link field to the name of the field in
the subform's recordsource which corresponds to the combo's bound
column.

Note that the name of the combo won't be on the dropdown list for
selecting the master link field, you'll need to explicitly type it in.

John W. Vinson[MVP]
 
S

sap4ora

Thanks John, that worked.

John Vinson said:
Set the Master Link Field property of the subform control to the name
of the combo box, and the child link field to the name of the field in
the subform's recordsource which corresponds to the combo's bound
column.

Note that the name of the combo won't be on the dropdown list for
selecting the master link field, you'll need to explicitly type it in.

John W. Vinson[MVP]
Click to expand...
 
Top