Combo box Value list to subform

[Guest]

Hello

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


Regards,

 

[John Vinson]

Hello

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


Regards,

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]

 

[Guest]

Thanks John, that worked.

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]