Display last update "date" on form

[BBeck]

I have a form that I update with a button that runs a macro to do the update. I would like to display the last update "date" under that button. I would assume it could be done via the macro but not sure of best way.

 

[ajetrumpet]

i am working with an individual right now that does this same concept in a table. he stores the current user name and ID in a table, and references that single record table whenever he needs the name or ID on form controls. you could do the same thing....

create a table that stores one field, a DATE. then update it dynamically everytime the button on the form is pressed. like this:

on_click

docmd.setwarnings false
docmd.runsql "UPDATE tableName SET tableName.FieldName = Date()"
docmd.setwarnings true

me.requery

then maybe have a label and text box underneat the button that displays the last update date and time?

label = "Last Updated On:"
textbox Control Source = "= dlookup("FieldName", "tableName")