Access - record navigation - back and forward

C

comsbill

Access 2003 XP

Any suggestions on how to accomplish moving between records in a form
on a last record viewed basis. I have a combo box that looks up
records, but would like to add some navigation (similar to a browser)
that would enable the user to hit a "back" button that would take them
back to previously viewed records - or forward as the case may be.

Seems to be something that many would want to do, but I cannot find any
techniques or VBA code posted on the lists.

Thanks, Bil
 
A

Allen Browne

Access does not maintain a list of the most recent records visited, so you
will need to create an array variable (or a recordset based on another
table), and maintain the history yourself.

Use the Current event to record the primary key value of the record
visitied.
FindFirst in the RecordsetClone of the form to go back to the record.
 
Top