ShowAllRecords removed my Sort

S

Sninkle

Access 2003

I have a form that is based on a sorted query. The form has buttons to
enable filter by letter (similar to the Northwinds Sample DB), the All button
has the macro command ShowAllRecords. Unfortunately this removes my sort.
How can I reapply the sort after the 'All' button is pressed without manually
selecting the menu Sort option.

Thank you
 
Top