Combo Box - Order of information

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

Hi

I have created a field with street names in it.

I have then created a combo box on a form that uses the
street table as the pull down.

However, even though I have sorted my table into
ascending order (right click - sort ascending), when I
view the pull down it is in the order I typed them in.

How can I change this.

Regards

Steve
 
Sorting the table is a visual item only. To sort the data for the combo box, create a
query based on the table with the field you want. Place the fields in the query (from left
to right) in the order you want them to be in the combo box's columns. Sort as desired in
the query. Use this query as the RowSource of the combo box instead of the table.
 
Oops

Sorted.

Thanks

Steve
-----Original Message-----
Sorting the table is a visual item only. To sort the
Click to expand...
data for the combo box, create a
query based on the table with the field you want. Place
Click to expand...
the fields in the query (from left
to right) in the order you want them to be in the combo
Click to expand...
box's columns. Sort as desired in
 
The "left to right" was if there was more than one field being returned if you had
multiple columns in the combo box. There are times this is appropriate and times it's not,
depending on what you're trying to do. The records in each field will be "vertical" as you
indicated.

I also saw your second message, it appears you got it going. Is this correct?
 
Back
Top