Combo Box - Order of information

[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

 

[Wayne Morgan]

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.

 

[Steve]

Oops

Sorted.

Thanks

Steve

-----Original Message-----
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

 

[Wayne Morgan]

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?