Pull through related info when combo is used

[Guest]

I have posted this before but unfortunately haven't got a working solution
yet....

Using a combo on our Orders form to look up and select a particular
corporate customer that is held in the Customers table, I want the contact
name for that selected customer to be shown on the form too.

How can this be done?
Many thanks
CW

 

[John W. Vinson]

Using a combo on our Orders form to look up and select a particular
corporate customer that is held in the Customers table, I want the contact
name for that selected customer to be shown on the form too.

Include the customer name in the Combo's row source; be sure that the combo's
Column Count is large enough to include the name.

Set the Control Source of a textbox on the form to

=comboboxname.Column(n)

where n is the zero based index of the field you want to see - that is, if the
name is in column 3, use (2).

John W. Vinson [MVP]