Form based on Ascending order of a field

[dealwi8me]

Hello all,

How can i get the records of a form based on a field ascending order (not the primary key), when i open it?

Thank you in advance.

 

[ansentry]

Base your form on a query (using the table as the source) you can then sort by any field in the query.

 

[Smart]

Create a query that selects all the required fields and sort on the field you require.
Base the form on that query

Or if the form is based on the table,look at form properties , data then type the field you want to sort on in the order by section

 

[dealwi8me]

Ok both ways worked!

Thank you both