sort in ascending order

T

Tom

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?
 
T

Tom

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

Klatuu

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"
 
T

Tom

thank you Klatuu, it worked

Klatuu said:
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"
Click to expand...
 
Top