Alphabetical Order

[Bill]

I have an employee DB
My main table, the primary keys are "Last Name"
& "Employee ID" - When I open my table the last names are
in alphabetical order - The way I want it to be.

I created a form based on the info from the table in
question. Only problem, the last names are not in
alphabetical order.

Intially, only the Employee ID was the primary key - I
added the Last Name as primary key after I created the
form - Is that why the last names are not in order?

I hope I explained this well enough - Thank you
I'm using Access 2000

 

[Van T. Dinh]

The Records selected for the RecordSource of the Form are retrieved randomly
for efficiency. If you want the Form to show Records in some order, use a
Query with sorting/ordering to sort the Records.

Alternatively, you can use the OrderBy and OrderByOn Properties of the Form.