Showing when a Database was last updated

[Syrch]

I've recently created a database for a few users here. My only issue is in order to make it easy for all involved i had to give everyone access to update the database. My concern with this is i have the data going to a make table from an append query. I do not have a delete query since the data can only be pulled daily from a nightly back up on our as400 and the users want to be able to see past data. If i run a delete query that data would be gone.

I want to create a label/button on the switchboard that will show when the last time my database was updated. I tried to create a query using my make tables data filtering date with the max function but when i create a label and use that query as my control source i get Name? as a result.

Does anyone know an easier way to do this?

Edit: Either googlez failed me or i failed at the googlez ;/

 

[KIAman]

Form_Dirty Event.

You can take their example and set your LABEL.TEXT = DATETIME.NOW

 

[Syrch]

But wouldn't that just give me the current date/time?

 

[KIAman]

The event will only fire when data is updated. And yes, it will set the label to the current date and time WHEN it was updated.

 

[Syrch]

Do i need to make the example they give a macro?