Subform Linked to an Unbound Combo Box

A linked subform provides another possibility of displaying data associated with a record identified by a combo selection. In this case, you use the built-in capability of subforms to display related data as you make changes. (For an example of this technique, see the "Combo 5" form in AC208.MDB.)

Suppose you want to display the customer information for a customer selected with a multicolumn combo box. Create a new form with RecordSource property set to the Customers table and create text boxes in it to display various Customers fields. Embed that form in a master form. Place an unbound (empty ControlSource) combo box with RowSource also set to the Customers table. Set the LinkMasterFields property to the name of the combo box, and set the LinkChildFields property to Customer ID. In Form view, whenever you select a row in the combo, the subform automatically shows the data corresponding to the selected customer.