Look up data in subform via cbo box on main form

  • Thread starter Thread starter Lysy
  • Start date Start date
L

Lysy

I would like to set-up a view form where a combo box will
be on main form and records will show on the subform , in
datasheet view. It would work by user selcting a customer
name on cbo main form and subfrom would show all the
orders in data sheet view.
Thanks for help.
 
Lysy,

Make the combobox so that the "Bound Column" indicates the field which
identifies the Customer for the order. Lets say this is CustomerID
field. Then, set the Link Child Fields property of the subform to
CustomerID, and set its Link Master Fields property to the name of the
combobox.
 
Back
Top