customize the sort order of a combo box

[BadKitty]

i have a combo box on a payment form which shows existing permit #s. i'd like to make the sort order show the most recently added permit first. i clicked on the build button next to RowSource on the data tab of the properties of the combo box which opens the query my combo box is based on. there are only 3 sort order options...ascending, descending, & not sorted. can this be done?

the permits form has a button to open the payments form (payments can also be opened alone too - ie. if somone applies for a permit today but pays for it tomorrow...). usually this will not be the case but that is why i have to keep it either combo or list.

all help is appreciated.

 

[RuralGuy]

Is there any field in the permits table that would indicate which record was the "most recently added permit"? Is it the largest Permit Number?

 

[selenau837]

I was thinking she needed to sort decending on the primary key field for that new record that was being added. Or on a date field that stores the date the permit was added.

 

[BadKitty]

thanx

i was looking for a complicated solution (i tend to do that & overlook the basics), but as soon as i read your replies i realized how simple accomplishing that task is...must've had a brain fart. thanx anyway! always appreciate the help.