Sorted Records in a Table

[Joakim N]

Hi,

How can I Sort records in Form attached to Table? In the form beneath, I want to sort the records on:
1. Last Name
2. First Name

But I can't find anywhere to sort. When I'm making a combobox, I can sort its list by a query. But showing the records in a table I can't find where to use a query. Maybe that's not possible, Shall I use these property for the form?:
- Order By
- Order By On Load



If I shall use these properties, what shall I write?

[aytee111]

You can use the properties, put the table field names, such as "JobMgrTable.LastName, JobMgrTable.FirstName"

Or you can use a query as your recordsource - in Design View, click on the three dots next to the table name and create a query from there. It will be a simple query, select all fields, sort by the your requirements

[Joakim N]

Thanks!

Appreciate your help,
\Joakim