keeping track of last 'n' records viewed

[Happy YN]

My user types selects a unique record number (not autonumber) from a combo to dislplay its details. How can I keep track of the last 10 records examined so the user can click a 'previous' button to return to it and another forward button to do the opposite? obviously when an 11th record is selected, it would 'bump off' number 1 from the list. Is it easiest to have a table which clears itself on exit or is a recordset better and what code would I use?
Thanks

 

[Mile-O]

Add a "last viewed" field to your table and every time a record is viewed run an UPDATE Query to change this field to the current date and time.

Sort all you records in a query by the LastViewed descending.

Use the SELECT TOP 10 clause.

 

[Happy YN]

Thanks -Thats good but it involves an extra field for the thousands of records.Wouldn't it be more space economical to make a small table with only 2 fields and keep it don to 10 records?
thanks again

 

[Happy YN]

I wish I could but I've no idea where to start. Any pointers?
Thanks

 

[Rich_Lovina]

Returning to Access after a long break, I've a need similar to this one. I've a current date for date entered and want to have an "Edited" field for date edited. Seems a long-winded way to have to run a query, when surely I could create a second date field, which onfocus or onclick will add the latest date??

Which way is this done and does anyone have a public/private function for it??

Thanks in advance any help.