Adding a Time Stamp to a Form

[Tomlon]

I have a simple form. On this form, it is simply a maintenance form. Currently, it has a single button and a txt box. The on Load of the form runs a SUB that checks if the computer has access to the home server to update the database. This is a local copy of a database that the user can use remotely or away from office. This form check the connectivity and if there is connectivity it the button is enabled. The user can push the button and refresh their local copy. This works great. What I want is a time stamp on this form that states when the last update was. I placed a label. I added a a sub in the module that runs after the data refresh. It simply changes the caption of the label to that date of the refresh. Well, this works great....until I close the form. When I open the form back, it is blank as it was before the refresh. What other way can I do this that will retain that time stamp when I refresh the DB. Thanks.

[June7]

The caption change is not saved because the form is not saved with the edit. This is a design change of the form. I have never done this with VBA. Google: Access VBA design edit form

An alternative is to have a table called UpdateInfo where the date can be saved. Can be only one record and the date is changed or can be a record for each change.

[1gambit]

http://office.microsoft.com/en-us/ac...001034535.aspx

Here is what I just used to help me. I used the 2nd option of attaching an event to the form. Even though it is a tip for 2003, it worked perfect in 2010