Order of forms

[Cathy]

How do i make the records in a form come up in alphabetical order by one of
the fields (e.g. surname) rather that in the record order shown at the bottom
of the page.
The order by in properties of the table is set surname.

thanks

 

[Allen Browne]

Open the form in design view.
Open the Properties sheet.
On the Data tab of Properties, locate the RecordSource property.
Click the elipsis button (...) beside this.
Access opens the query designer.
Using the Sorting row to sort by surname, just as you would in a query.
Close the query designer, answering Yes to the "Update...?" question.