Create a "recall" button?

[Guest]

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?

 

[Allen Browne]

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.