combo boxes

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

 

[Gerald Stanley]

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

 

[Chrisx]

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
.