Sorting Records on a form

  • Thread starter Thread starter Andrew
  • Start date Start date
A

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.
 
---------- "Andrew said:
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.
Click to expand...

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
 
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?
Click to expand...

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