List of recently accessed records?

[CW]

Currently we select the required record by using one of a couple of combos on the intro form in our database - one to find by customer name, the other to find by file ref.
As we tend to jump around and visit current records quite a few times every day, it would be really handy to have a dropdown list of recently accessed records, just as provided in most applications (e.g. in Word, the most recently accessed docs). Clicking on one of these would take you straight to the record.
Is there a way of doing this?
Many thanks
CW

--

 

[John W. Vinson/MVP]

Currently we select the required record by using one of a couple of combos on the intro form in our database - one to find by customer name, the other to find by file ref.
As we tend to jump around and visit current records quite a few times every day, it would be really handy to have a dropdown list of recently accessed records, just as provided in most applications (e.g. in Word, the most recently accessed docs). Clicking on one of these would take you straight to the record.
Is there a way of doing this?
Many thanks
CW

Not without creating a table in which to record record accesses, and
using VBA code in each form's Current event to record that
information. This will get REALLY snarky in a multiuser application -
you would need to put the trace table in each user's frontend, which
will cause bloat.