How to make form display records in order?

Topic

New Reply

I have a form that I would like to have sorted and displayed by last name (Lastname). How do I do this? I sorted the underlying table but that does not seem to help.

Reply | Quote

Replies

Create a query based on the table that sorts the records the way you want, and use the query as record source for the form.

BTW, unlike forms, reports ignore the sort order of their record source. For a report, you must specify the sort order in the Sorting and Grouping dialog.

Reply | Quote

Thank you. Does this mean I will need to run the query each time I open the form in question? If so, how can I automate that so that new record entries will be correctly sorted when I next open that form?

Create a query based on the table that sorts the records the way you want, and use the query as record source for the form.

BTW, unlike forms, reports ignore the sort order of their record source. For a report, you must specify the sort order in the Sorting and Grouping dialog.

Reply | Quote

Does this mean I will need to run the query each time I open the form in question?

No! If you set the Record Source property of the form to the name of the query, the form will automatically run the query when it opens. You don’t have to do or set anything extra.

Reply | Quote

Cool! Thanks again.

No! If you set the Record Source property of the form to the name of the query, the form will automatically run the query when it opens. You don’t have to do or set anything extra.

Reply | Quote