How can I sort my data in alphabetic order?

MS Access 2003 I have a form which users can browse to search for data; they can resort the form anyway they like but at the end I would like to have the original sort order back, when closing the form users shouldn't be allowed to save the modified form.

• Answer:

  Make sure that the Form is based on a Query and the Query is set to sort by the field you want as the primary sort order. Open the Form in Design View, right click the small grey box at the top left of the Form and select Properties. Select the Event tab of the Properties sheet and then click in the 'On Open' input box. Click on the Builder button that appears to the right of the 'On Open' input box and select Macro Builder. In the first line of the Macro Builder select 'Apply Filter' and type the name of the query on which the Form is based where it says 'Filter Name' at the bottom of the Macro Builder window. Save the Macro and every time the Form is opened it will be sorted the same way as the underlying query.