B
barret bonden
Trying to save the date of any changes on a data form.
Private Sub Form_BeforeUpdate(Cancel As Integer)
If Me.Dirty = True Then
Me.[last_updated].SetFocus
Me.[last_updated].Text = Date
'Me.Refresh
End If
End Sub
And I get:
the macro or function set to the beforeupdate property for the
field is preventing MS Access from saving data in the field.
It works w/o this error when I just page to and from records, but fails on a
combo box search
Private Sub Form_BeforeUpdate(Cancel As Integer)
If Me.Dirty = True Then
Me.[last_updated].SetFocus
Me.[last_updated].Text = Date
'Me.Refresh
End If
End Sub
And I get:
the macro or function set to the beforeupdate property for the
field is preventing MS Access from saving data in the field.
It works w/o this error when I just page to and from records, but fails on a
combo box search