List of records accessed

[Alan]

Is it possible to save a list of records accessed via a form so if you move
to another record you can then view that list and move to that record if
required. This would be a most useful thing as many times you are part way
through editing a record, the phone rings and you have to move to other
records. Then try and remember which record you were working on so you can
go and finish editing. Keeping the list to say the last 6 records viewed
would be fine.

Thanks in advance for any pointers.

 

[Guest]

Make a table that contains the primary keys of all records opened in the
current session. Append the current record number to it in the Form_Current
event, and flush the contents on closing the form or the app (and also on
opening the form/app, in case the close one gets bypassed somehow). If this
is a multi-user app, you would need to record the UserID also to avoid having
all users' viewed records intermixed & thus indistinguishable.

You could have an unbound combo box on your form that draws from the table
of recently-opened records, and allow the user to pick one, then do a
bookmark to move to that record.

It would also be pretty easy to record the time a particular record is opened.