Northwind database



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.


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:



Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question