Order of records on the form

  • Thread starter Thread starter Samuel
  • Start date Start date
S

Samuel

Hi

For some reason when I add a new record it is not the last record on the
form

What is the cause of it and what in fact sets the order of the records

Thank you,
Samuel
 
Dear Samuel:

The form can be based on a table or a query. Think of the records in a table
as a "bag of records" - unordered. If you want to place an order on the
records in a table, create a query - then base the form on the query.

HTH!
 
The strange thing is that it never been like that before?

Is it possible that it is due to importing the table from another database?
 
Dear Samuel:

Possibly. In any case, you can't trust a table to have a specific sort
order - create a query and use it to assign an order. You'll be happy you
did! <g>
 
You may have clicked in a form field and sorted on it. Access saves this
information when the form is closed. Open the form in design view and
remove any order by or filter that you don't want.

As has already been mentioned by Fred, you need to control the sort order
yourself by using a query with an order by clause. If you want to order
records by their entry order, you need to use an autonumber as the primary
key for the table and sort on that.
 
Back
Top