Sortin in a combo box

  • Thread starter Thread starter Damien McBain
  • Start date Start date
D

Damien McBain

Hi ya'll, a little help if you please.

I have a field in a table whose default control is a combo box with a row
source table which has 3 columns (fields). I store the value from the first
(bound) column, don't want to display the second one and choose a value from
the third. I want to sort by the second (hidden) column. The row source
table is sorted by that (second) field but the combo box always sorts by the
bound (first) column.

How can I achieve what I want here?

TIA

Damo
 
Damien said:
Hi ya'll, a little help if you please.

I have a field in a table whose default control is a combo box with a
row source table which has 3 columns (fields). I store the value from
the first (bound) column, don't want to display the second one and
choose a value from the third. I want to sort by the second (hidden)
column. The row source table is sorted by that (second) field but the
combo box always sorts by the bound (first) column.

How can I achieve what I want here?

TIA

Damo
Click to expand...

Got it, use a select query as the row source. Thanks Google.
 
Back
Top