record sorting in a form

  • Thread starter Thread starter pvp
  • Start date Start date
P

pvp

Access 2000.
I have a form I use to manage records in a table.
When I enter a new record, the order of the records
visible through the form remains the one that reflects
the indexes of the table EXCEPT that the record I just
put in is always at the end, regardless of its key
value.When I exit the form and re-enter it, the newq
record is in the right place in sequence.
How can I resort the table behind the form so that the
new record appears in the right place in the table
without re-starting the form?

Thanks.
 
Requery the form to cause it to reload without closing.

Naturally enough, this will throw you back to the first record (i.e. you
will no longer be at the record you were at before the Requery).
 
Back
Top