Need Combo Box Help!

[Scott]

How do I use a combo box to pull up multiple fields at the same time? Or do I use something else? For instance, in the Northwind database sample "orders" form, when you select a company name the rest of the address fields come up (street, City, State, Region, etc). I use MS Office 2000.

Thanks,

Scott

 

[Reddy]

Hi Scot
Here is the example
1 Combo1.Rowsource = "Select Last_Name,First_Name,Phone_No,Fax_No From Employees
or what ever the fields you want from the table or just give the table name, you will get the field values as is in the table

2 Set the column count of the combo box property to 4 or how many columns you want

3 Set the column width property to 1;1;1;1 the higher the number, the width of each column will increase

You are done :

 

[Reggie]

Look under help and type in Combo_box. Then click "Create a bound or
unbound combo box. drop-down list box, or list box". Tells you everything
you need to know.

How do I use a combo box to pull up multiple fields at the same time? Or do
I use something else? For instance, in the Northwind database sample
"orders" form, when you select a company name the rest of the address fields
come up (street, City, State, Region, etc). I use MS Office 2000.

Thanks,

Scott