How do i show the date a report or query was last run?

[Sean Bishop]

I am using Access 2007.

I have several reports and queries which are run on a fairly regular basis.
What I would like to be able to do is show the date the report was last run.

Is there any way I can show this on a form which would show the name of the
report or query and the date it was last run.

Thank you for any help you can give me.

Sean Bishop

 

[KARL DEWEY]

The easiest way I know is to have whatever triggers your report to also
append a record to a table and to use DLokup on form to display Max dated
record.

 

[Arvin Meyer [MVP]]

If you are starting your report from a form (like you should be doing), add
a datefield to the underlying data table and a line in your code will save
the run date to that field overwriting the previous entry. Something as
simple as:

Me.txtDateField = Date

should work, assuming txtDateField is the name of the textbox, with that
data.