Sort with Combo box

  • Thread starter Thread starter Lovespar
  • Start date Start date
L

Lovespar

I have a combo box on a form where I use an update event where the form will
choose the record selected from the combobox.
The source is a table, and I want the dataentry person to be to update the
table because some of the fields will initially be empty.
The table is sorted in alphabetical order. The combo wizard asked me if I
wanted ascending order and I said yes.
Why is my data not sorted correctly?
Is there something else I need to do?
thanks in advacne
 
The table is sorted in alphabetical order.
No, tables are not sorted. The data stored in tables is like a barrel of
bricks, just a jumble. Sorting is to be done where data is dispalyed and
viewing of tables is the wrong way to do it.
That wizard question is for the sorting of sellection offering display only,
not the display of your records.
The display sort for your records needs to be in the query or SQL statement
used as form Record Source.
 
Instead of basing the combo box on the table, create a query that sorts the
records like you want, then base the combo box on that query.

Also if you are using lookup fields on the table in question, that can mess
up things like your combo box. It might look like you are sorting on
something, but what is really sorted is hidden. One reason to not use lookup
tables in fields.
 
Back
Top