Records not in order

  • Thread starter Thread starter David Medlin
  • Start date Start date
D

David Medlin

I have a simple database (one main table, a couple of
lookup tables) with 2800 records. We recently upgraded to
Office 2003 but I don't think that had anything to do with
my problem, the rest of my databases are fine.

The database has an autonumber field which is the primary
key, indexed with no duplicates.

I have a form for data entry and editing. When I use the
form now, the records no longer display in order. When I
look into the table, everything is in order but the form
just diplays them in a seemingly random order.

Any ideas?

Dave
 
Create a query with an ORDER BY clause in it, and use the query as the
recordsource for the form, not the table.

You can never assume anything about the order in which records will be
returned from a table unless you do this.
 
Back
Top