[AccessD] Before update problem

You might try to set the date using the on dirty property of the form. This
fires when you change the value of a bound control.

Doug

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Doug Barnes
Sent: Wednesday, June 13, 2007 11:19 AM
To: accessD at databaseadvisors.com
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 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

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