To comp.databases. ms.access --
I know that the recommended way to detect an update to a form, is to
use the form's "Before Update" event, and putting in VBA code like:
Private Sub Form_BeforeUpda te(Cancel As Integer)
Me.Last_changed _date = Date
End Sub
Then, the field "Last_changed_d ate" on the form would show the date of
the most recent update.
HOWEVER, in my case this does not work the way I want it to. I have a
field on the form that gets automatically updated, based on the value
of a field in another table. (This is done by a function that is
invoked on the "On Current" event for the form, and the "On Lost Focus"
event for one of the fields in the form.) This has the effect of
setting "Last_changed_d ate" to today *whenever* the form is opened --
which is NOT what I want to do. What I really want to do is update
"Last_changed_d ate" only when the user actually, MANUALLY, keys data
into the form. Does anyone know how I can do this -- hopefully in not
too complicated a manner? Thanks much & happy holidays!
--Tom