combo boxes

  • Thread starter Thread starter Chrisx
  • Start date Start date
C

Chrisx

I would like to retrieve data for my form, based on a
dropdown list in a combo box. The problem I have is that
I need 2 fields to be selected to find the unique record
in a table. Can this be done with a combo box? The
wizard only allows 1 field to be selected.

Thanks for any help.
 
Try something along the following lines

1. Change the RowSource Query/SQL to select the two columns
that you want.
2. Change the Number of Columns to 2
3. Set the ColumnWidths property as you see fit - ; acts as
a seperator
3. Then, when selected, the second value may be accessed as
Column(1) property of the combo box.

Hope That Helps
Gerald Stanley MCSD
 
Thanks Gerald. That worked for me.
-----Original Message-----
Try something along the following lines

1. Change the RowSource Query/SQL to select the two columns
that you want.
2. Change the Number of Columns to 2
3. Set the ColumnWidths property as you see fit - ; acts as
a seperator
3. Then, when selected, the second value may be accessed as
Column(1) property of the combo box.

Hope That Helps
Gerald Stanley MCSD
.
Click to expand...
 
Back
Top