Capturing 'Last modified' information on Switchboard

[asma410]

Is it possible to display the file created & file modified information on a switchboard? I have designed the database so that when the user clicks on an icon on the switchboard, a form (linked to a table) with records will be displayed. Whenever the user modifies any record in the form, I want the date & time to be captured & stored on the switchboard. I don't care about the date & time when each record was modified (I have already implemented that functionality). I am interested in keeping track of the last time ANY record was modified in ANY form.

PS: Swtichboard is the first item the users will see when they open this database & it would be great if the information is displayed on it. As of now I have only 1 form linked to the switchboard but I will be adding more forms in future.

Any help would be appreciated.
Thanks

[PEB]

Hi,

So u need that in your table u Put a TimeStamp that will be filled in with the las time of updating of your record!

Then this is a simple query to get the information from the latest update of your table!

U can also put in your table the form name that have been modified the record!

And also the user as well!

But this info has to be in your tables!

:)

[asma410]

Hey PEB,
It works!! Thanks a lot.
I was already using the TimeStamps so it was a lot easier. I prefixed the DateModified & TimeModified field names with the table name (ex: tblDrive_DateMo dified & tblDrive_TimeMo dified), so that I could compare the fields of different tables using the same query.
I was thinking on the lines of doing an 'Audit Trail' but queries offer a very simple soultion. Talk about thinking outside the box.
Thanks again.