Open at last record viewed
I have a database that allows users to 'Archive' a record by placing the value 'Archived' in a field.
Open next open, the database will perform a find of all records where the value in this field does not equal 'Archived'. Leaving the found set showing only un archived records. This woks well enought, but when the database opens it always opens at the first record in the found set, being the oldest record.
How can I keep the archiving function and have the datbase open at the last record that was viewed before shutdown.