sort in ascending order

[Guest]

I have a form with cliens' last and first name made from a table not from a
query. I want to view records (the names) in ascending order, instead of ID
(primary key-auto) on the form. How I can do that?

 

[Guest]

Use the Order By property of your form

 

[Guest]

I didn't get it. Can you be more specific or in details, I'm sorry I'm green
to Access.

 

[Guest]

Tom,
In design mode for your form, click on Properties. One of the properties is
Order By.
Enter the name of the field(s) you want to sort by.
"LastName, FirstName"

 

[Guest]

thank you Klatuu, it worked

Tom,
In design mode for your form, click on Properties. One of the properties is
Order By.
Enter the name of the field(s) you want to sort by.
"LastName, FirstName"