Last Update Control

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want a field in my form that shows the last time the subform was updated.
How would I do that?
 
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..
 
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...
 
I thought I could use the "After Update" control on the subform but I'm not
sure how to do that. Any ideas?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Main Form and two Subforms 2
tabbing thru subform doesn't work 1
Requery to update data 6
Access Daily Entry with multiple entries per field 0
Tabbing through form w/ subforms 1
Set Change Event on Control from Nested Subform 0
Delay in getting subform total to calculate 2
Copy data from 1 subform to another subform 2

Back
Top