Populate Update Date on Form

[herrld]

I have a form (Form1) with a Command Button that runs a Macro (UpdateMacro). The Macro runs 4 update queries. When last query is complete, a message box opens with 'Update Complete'. User clicks OK, and the macro reopens Form1 in maximized view. I want a field on the form that will show the date/time of the last time the UpdateMacro was run and completed.
I used Set Value from within the Macro to go to the control on the form and enter the current date/time, but that entry disappears when the form is closed and reopened.
Any suggestions on how I can make that date/time field stay populated until the macro is run again sucessfully. I am also going to use that field on a report.

Linda Linda

 

[Rolliee]

Use the 'onupdate' to:

me.edit
me.datefield = now()
me.update

Rollie E