Last Update Control

A

awach

I want a field in my form that shows the last time the subform was updated.
How would I do that?
 
T

TonyT

Hi awach,

you could use the On Current event of the subform with something like;

Me.txtBox1 = Format(Now, "dd/mm/yy hh:mm:ss")

(english date format, change as required:p)

TonyT..
 
A

awach

I don't have a On Current event.

TonyT said:
Hi awach,

you could use the On Current event of the subform with something like;

Me.txtBox1 = Format(Now, "dd/mm/yy hh:mm:ss")

(english date format, change as required:p)

TonyT..
Click to expand...
 
A

awach

I thought I could use the "After Update" control on the subform but I'm not
sure how to do that. Any ideas?
 
Top