New record jumps above previous record on the form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using Access 2003 and have a subform which when I enter a new record, it
appears to jump above the previous record entered. This then causes problems
as the operator does not notice until she has typed over the previous record
details. There is no sort on this subform but I have noticed that it appears
in the same order as the table after this occurance has happened. I have
tried the repair and compact facility but to no avail.
Can anyone help put me out of my misery !!
 
Michael,
Your new records are jumping up into the recordset because that's the
sorting order you've requested. If no sorting is indicated in the form
query, the "natural" sorting of the table takes precedence. (I think any
Indexed/Key Fields take control).

But... you do not mention how you want to see the records sorted.

If you want to sort by "Last record entered is Last in sort", then you
should be sorting on a field that yields that order. Like a Key field
autonumber, which increments +1 for each new record, or a DOC field (Date of
Creation) that Date/Time stamps each new record. Sorting in your query on
either of these examples (Ascending) would stop the jumping problem.
 
Do you have a requery on the after update event of the subform, that can
cause the records to be re ordered, either remove the form requery, or add a
sort to the record source of the form by the key field that indicate the
order of the inserted records.
 
Al, thanks for your reply.
I forgot to add that this does not happen all the time and the operators
could be punching all day and it wouldn't happen and then happens regularly
other days. I have checked and there is no requery in the after update code
for this field. I cannot see any sort order obvious after this happens for
any of the fields in the table although I would like it to have stayed in the
same order it was entered. A had thought of a time field sort but it took
too long to run as there are 96,000 records in the table at present. Any
other bright ideas would be appreciated.
 
Back
Top