Return to previous record after edit

[demogorgan]

Hi,

So I have an input form that users key into, however whenever they edit or enter a new record after they hit the next button it always reverts back to record 1.

I would like the form to stay on the current record after the user has finished editing / creating the record.

The reason for this is orders are sorted by dates and they can have to update many records in one session, so it can be frustrating to have to manually go back to the record they were working on just to go the next one.

From what I can ascertain it would be a bookmark that would hold the record number being worked on and then retrieve this number to jump back to it.
Does that sound about right ? I have tried to get my head round it but I am drawing a blank.

Thanks in advance
Demo

 

[Pat Hartman]

Stop refreshing/requerying the recordset after you update a record. Then Access won't move back to the first record in the recordset.

 

[isladogs]

As Pat says, requerying will cause the data to move to the first record.
I don't think refresh will do that but I don't think it will do anything useful either

If the data doesn't update on the screen for some peculiar reason, try Recalc instead of Requery. That shouldn't shift the focus to the first record

 

[arnelgp]

Dont put Sorting Order on the form.
Create a query with Sorting in place and use that query as your record source instead of the table.