Saving a form's sort field

[JVermast]

I have a form that has a bunch of project information and scrolling buttons at the bottom to browse by next/last.

Right now the form is sorted by the ID associated with the project, which kinda sucks because they were and are not put in alphabetically.

I discovered if you right click on a field and click "Sort Ascending" or the opposite it works fine but when I open the database it is right back to normal ID sort

I have checked the Data and Other tabs but can't find anything with regards to this as well as I have tried sorting the actual table by name and that changed nothing.

Any help would be greatly appreciated.

 

[Oldsoftboss]

Base the recordsource on a query of the table that sorts the data.

Dave