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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combo Box QUESTION 5
Cascading Dependant combo boxes 0
Combo Box Problem 23
Access 2003 Combo Box 4
Combo Box Sorting and Selecting 4
Access Combo Box display 1
Combo box trouble 1
Changing the Selection Fields in a Combo Box 4

Back
Top