Northwind database

[Guest]

I am trying to reproduce the action in which you select a customer from the
combo box and the address changes along with it from the Orders Form of the
Northwind Sample Database. I am sorry my Show Me fuction isn't working on my
computer. Thanks for your help.

 

[Guest]

To *display* other fields from a combo box' Row Source, either base the form
on a query that includes the fields you need (including the key), OR select
the fields you wish in the combo box, and display them with the Column
property of the combo box. Column is 0-based, so the index to the first
column is 0.

For example, to display the third column from combo box cboCustomer in a
textbox, set the TB's Control Source to:

=cboCustomer.Column(2)

HTH
Sprinks