form alphabitizing not working

[Richard_Denver]

So my Last & First names are not alphabitizing on a form

I've indexed them in the table, and that works fine

So why doesn't it work on the form?

I'm using Access 2007, I have a table with 20,000 plus record with first & last name

 

[Mr. B]

You do not indicate what method you are using to get the data to the form.

If you are simply using the table as the record source for your form, the records will appear in the order they exist in the table.

If you want to be able to specify the sort order for records, try using a query (even if you are going to display all records from the table) that selects the records you want and in this query you can specify the sort order. Use this query as the record source for your form.

 

[Galaxiom]

Tables are unordered. There is no reliable way to control the order of the records particularly once records have been deleted. They can be displayed in an order by applying a sort to the table display but this does not affect the underlying order.

As Mr B says it is best to use a query as the record source of the form. This can either be a stored query or sql typed into the record source property box. I prefer the latter as this does not clutter the database with more queries. However the stored query can be a faster option because the execution plan is retained after the first run of the stored query.

The other way is to apply a sort to the form itself.