last updated

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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,
 
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")
 
Back
Top