Combo Box

[AMF]

I have a combo box created for company name (which is
from tblCustomers) and was able to get that to work just
fine. What I am wanting to happen after choosing a
specific company is for the company information (such as
billing address and phone number, which is also from
tblCustomers) to appear right below the combo box. I
have not been able to get it to pull up this information
at all.

Thanks for your help!

 

[Wayne Morgan]

Try including these other fields in the combo box's Row Source. Set the
width property for the columns for these other fields to 0. In the text
boxes below the combo box, set their Control Source to an equation that
refers to the appropriate column in the combo box.

Example:
=cboMyCombo.Column(1)

The column number is zero based, so the first column is 0, the second is 1,
the third is 2, etc.