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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Enhanced paragraph sort - is it possible? 0
how to remove filter created by synchronized combo on continuous f 8
Error 3085: Undefined function 'N' in expression. - Access 2010 1
Multiple Challenging Excel needs.... 0
If else subform reference access 2007 2
switch from datasheet view to form view and reapply filter/sort 0
ADVANCE FILTER SORT WINDOW 1
Filter macro stopped working in 2007 0

Top