[AccessD] Before update problem

Doug Barnes doug at starntech.com
Wed Jun 13 13:19:21 CDT 2007


Hello listers

I'm having a devil of a time. I want to update a Date/Time field when/if the
data has been changed on a form. The form is bound to a table and all fields
on said form are bound to fields in the table.

Access 2007 Trial version
Windows XP sp2

Here's what I've tried so far:

This didn't work
Private Sub Form_BeforeUpdate(Cancel As Integer)
    Me.QUOTEDATE = Now()
End Sub

Any help would be grateful


Doug Barnes

Starn Technical Services
P. O. Box 1172
Meadville, PA  16335
Ph 814.724.1045
Fx 814.337.3460
doug at starntech.com




More information about the AccessD mailing list