You would need to use the Current event of the form to record the primary
key value. If the primary key is editable, you would also need to use the
AfterUpdate; otherwise AfterInsert.
You can then return to that value by using a FindFirst on the RecordsetClone
of the form, and setting the Bookmark.
To remember the pk, you could just use a module-level variable if you just
need 1 level of recall. If you want to be able to keep going back (like the
Back button in a browser), you will need to use an array, or log the records
in a table.
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users -
http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Ricter" <(E-Mail Removed)> wrote in message
news:95E7BA03-732B-4027-9897-(E-Mail Removed)...
> I'd like to create a recall button that works like the one on a satellite
> receiver remote, ie. when I click it I go back to the last channel
> (record) I
> was viewing. Can anyone sketch out how I would do this?