[AccessD] Before_Update problem

Doug,

You probably need to use a different event to change data.  Try using
AfterUpdate.

Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Doug Barnes
Sent: Wednesday, June 13, 2007 12:59 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] Before_Update problem

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 to fields in the table.

Access 2007
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

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com