Sorting Records on a form

[Andrew]

I made a combo box that has all the records in my table. How to I make it
display alphabetically according to the first column?
After I add a new record it goes to the top as well.

 

[Emilia Maxim]

I made a combo box that has all the records in my table. How to I make it
display alphabetically according to the first column?
After I add a new record it goes to the top as well.

Andrew,

create a query based on the table and set the query as the row source
of the combo. You can do this by opening the properties window,
clicking into the property field and clicking the ellipsis at the
right end of the property. Then you can set whatever sorting needed in
the query.

Best regards
Emilia

Emilia Maxim
PC-SoftwareService, Stuttgart
http://www.maxim-software-service.de

 

[John Vinson]

I made a combo box that has all the records in my table. How to I make it
display alphabetically according to the first column?

Base it on a Query sorting by whichever field or fields you choose,
rather than basing it directly on the Table.