find last modified record

[Guest]

I have a database that contains work orders that multiple users are accessing
to find out what work they should be doing, and for them to report back on
the completion of their projects. When the workers complete a project, they
are asked to enter their name or initials onto the form that is displaying
the information about each project.

I want to create a button that will quickly take the worker to the last
record that s/he modified. I already have DateModified and TimeModified
fields that are being automatically updated through a macro that is triggered
by the BeforeUpdate form property. I need to know how to create a search that
will find the most recently updated record for a user's name/initials, and
then display that record in the form so that the user can review the last
record s/he worked on, and then click -> next record to go to the next
project in the queue. That would mean that I do not want a Filter-by-form
search where only 1 record is displayed.

I've been thinking that I want to work with the record number, such as
saving the number of each of the most recently updated records for each user.
I could add an autonumber field to the table if necessary.

The goal is to create a quick method for getting the worker back to the
record s/he was working on last. Any ideas would be helpful. Thank you.

 

[Nikos Yannacopoulos]

If I understand this correctly, all you need is the recordsource of your
form to be a query which filters on user and sorts descending on Date/Time
modified!
By the way, what's the point in using separate fields for data and time? One
field would do it just fine; all you would have to do to filter on dates
would be a Int([DateTimeModified]) = XXX instead of [DateModified] = XXX. It
would save you storage space and design complexity.

HTH,
Nikos