Combo box Value list to subform

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

Guest

Hello

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


Regards,
 
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]
 
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...
 
Back
Top