Need Combo Box Help!

  • Thread starter Thread starter Scott
  • Start date Start date
S

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
 
you can "show" multiple fields in a combo box droplist by adding the additional fields to the RowSourceproperty's query or SQL statement. then adjust the Column Count property of the combo box, and set ColumnWidths for each row. example: a combo box with four columns, bound column is column 1 (the primary key field), column widths are set as
0";1";1.5";.5"
note the primary key field, though it is the BoundColumn, is hidden in the droplist view. and remember, you can show multiple fields in a droplist, but only the value in the BoundColumn will be saved in the control's ControlSource field.

hth

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
 
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.

The query that is required, if you do it the easy way, is shown in the
Northwind orders form.
 
Tina...your reply helped partially answer one of my questions below: "Haing Problems with Table". However, even trying this my bound column isn't showing up (like it's supposed to), but my first visible column is supposed to say something like 'mixer' or 'forklift', but instead, shows a number. Any idea? Or, could you please take a look at my prevous question

Thanks!
 
i'll answer your original post, rawley. give me a bit of time, then check
there.


rawley said:
Tina...your reply helped partially answer one of my questions below:
Click to expand...
"Haing Problems with Table". However, even trying this my bound column
isn't showing up (like it's supposed to), but my first visible column is
supposed to say something like 'mixer' or 'forklift', but instead, shows a
number. Any idea? Or, could you please take a look at my prevous question?
 
Check the RecordSource Query of the Orders Form in NorthWind.

IIRC, the Customers Table (and its Fields) are included in the RecordSource Query.

--
HTH
Van T. Dinh
MVP (Access)



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
 
Back
Top