I have a LastEdit date/time field that updates on the Form_Dirty event when any data that is directly entered in that form is changed. However, I have a number of subforms, and it is equally important to update LastEdit when any of the data in the subforms is changed, but I can't seem to find an event that manages that. The LostFocus event can be used to trigger the LastEdit update, but it should not happen if you just click in a subform field and then back to the main form. I have tried this in the main form:
Private Sub subNotifications_Exit(Cancel As Integer)
If Me.subNotifications.Form.Dirty Then
Me.txtLastEdit = Now
End If
End Sub
Using the Form_Dirty event from the subevent does not work. I can put a
field in the subform, and have its date update from the AfterUpdate of any
field in the subform, then make the main form LastEdit update on the
subform's LostFocus event, but seems to me there should be a better way.
Any ideas?
Tobi Hoffman
Dept. of Youth Services
Boston, MA
------------------------ Yahoo! Groups Sponsor --------------------~-->
<font face=arial size=-1><a
href="http://us.ard.yahoo.com/SIG=12hnphl99/M=362131.6882499.7825260.1510227/D=groups/S=1705115370:TM/Y=YAHOO/EXP=1123015444/A=2889191/R=0/SIG=10r90krvo/*http://www.thebeehive.org
">Get Bzzzy! (real tools to help you find a job) Welcome to the Sweet Life
- brought to you by One Economy</a>.</font>
--------------------------------------------------------------------~->
Please zip all files prior to uploading to Files section.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AccessDevelopers/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
<<application/ms-tnef>>
