fix add new record in the bottom of database (1 Viewer)

[qupe]

hi
as in title i have database and user form it was working good until today .
before when i enter new record it stay at the end of the database, but now when i add new record ans close the database and reopen it the record become first not just in user form but also in database ,and i am not doing any type of filtering .



i appreciate any help .

 

[RuralGuy]

You need to use a Query and order the sort any way you want. Access treats tables as a bucket of records and returns them as quickly as possible.

 

[sneuberg]

Why do you care where the record appears to be? What's the problem?

If you want records to appear in order of entry it would probably be best to have date/time field with a default value of Now() and sort on that. Second best would be to sort on an autonumber but they are not absolutely guaranteed to be in order of entry.

 

[JHB]

Maybe you've change the sort order at table level.