Alphabetical Order

  • Thread starter Thread starter Bill
  • Start date Start date
B

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
 
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.
 
Back
Top