Combo Sorting

[expublish]

Hi,

I have a combo box on my form that lists peoples names. When a name s selected it displays their record below.

Currently, it is listed in order of Person ID (keyfield). How can I make the combo list the peoples names in alphabetical. I am aware that you casn do it by creating a query and basing the combo on the query, but it would be easier if there was a way to do this without changing the record source.

Thanks in advance,

Scott.

 

[Fizzio]

Can't get much easier than basing it on a query - also allows for a lot more flexibility. I know its not a solution but just my two-pennies worth

 

[mccaulj]

Go into properties for that field on the form. Under Row source, it should show where the data is coming from. If you click the three dots to the side, it will open up a window that looks like a query. It is actually something to do with sql (don't ask me). Change the sort properties for the field that you want it to sort by and then exit. Say yes to saving the changes to sql. This does not create a query, it just changes the sort order of the combo box.
Good luck!
J.McCaul