Look up data in subform via cbo box on main form

[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.

 

[Steve Schapel]

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.