Sort order in form issue

[Guest]

I have a form that displays contact details from a table. When I do a search
on any field using the standard search button & want to scroll thru the
records, it sorts by the RecordID field which is the primary key field. In
the form properties I have defined the Sort Order by:

tblContact.LastName, tblContact.FirstName

But it still scrolls thru using the Record ID. This is a pain where I am
search for say LastName is Smith. Where am I going wrong? TIA

 

[fredg]

I have a form that displays contact details from a table. When I do a search
on any field using the standard search button & want to scroll thru the
records, it sorts by the RecordID field which is the primary key field. In
the form properties I have defined the Sort Order by:

tblContact.LastName, tblContact.FirstName

But it still scrolls thru using the Record ID. This is a pain where I am
search for say LastName is Smith. Where am I going wrong? TIA

It's not enough to set a Sort order.
You must then right-click on the form and select Apply Filter/Sort.

A better solution if you always want to display the records in
LastName, FirstName order would be to create q query, sorted according
to LastName, FirstName. Use the query as the form's record source.