last updated

T

Tina

I have a form where the record source is a query (that gets it's information
from a table). The form footer shows the current date using the Now()
function. Is there a way for me to also include in the form footer the date
when the table was last updated?

Thanks,
 
A

Allen Browne

Access does not give you the date when the data last changed in the table.

You can do it if:
a) All data is added/modified through a form.

b) You add a Date/Time field named (say) UpdatedOn to the table.

c) You add this line to the BeforeUpdate event procedure of your *form*:
Me.UpdatedOn = Now()

d) You set the Control Source of your text box to:
=DMax("UpdatedOn", "Table1")
 
Top