Ordering records on a form

  • Thread starter Thread starter Simon
  • Start date Start date
S

Simon

In Access 2000 i am displaying a series of records on a
continuous form and i want to order them alphabetically by
one of the fields. i assume that if they are
alphabetically ordered by that field in the table, this
will solve my problem.

But...
I am using an autonumber and when a new record is added to
the table it will not fit in with the order, because it
will be placed at the bottom of the list, and therefore
not in alphabetical order.

So is there any way on the form to specify which order to
place the records?

Thanx

Simon
 
To specify the order within the form, base the form on a query, or SQL
statement The query will be quite simple, something like

Select * from MyTableName order by MySortFieldName
 
Say query instead of table and you have it. If that form is based on a
table, change the data source to a query based on that table. Sort
ascending on the field of interest.

hth
 
Back
Top