Jump to next record.

[fcmsb13]

I have a main pool of records (about 20,0000). Next to each record is a button that opens up a form. The popup form allows different fields on that record to be edited. I need to be able to have a requery code in the popup form that will requery the main form's records and automatically jump the the last record that was modified (or if that record was deleted jump to the next record). I have no idea where to start!
Thanks,
Paul

 

[Compressor]

Don't know for sure, but it seems that you have the same question as me. The Bookmark function seems to be the answer.
http://www.access-programmers.co.uk/forums/showthread.php?t=116812
Thanks to ansentry.

 

[ansentry]

Thanks to ansentry.

The code is not all my work, I found it somewhere and made changes to suit.

Have a look at the "New" attachment, I have fixed a problem with the DataID being Enabled = False.

If you just copy the code from the old version into you db and make changes to control names etc then you would not have had a problem.

Hope this helps.