[AccessD] Before_Update problem

Do you have any before or afterupdate events on the controls rather than
the form?  Is QuoteDate the name of the control or the field it's bound
to?  If they have the same name, that could be part of your problem.  If
you have an event in the QuoteDate control that will trigger the
BeforeUpdate or a save, you'll get yourself tangled into a stack
overflow eventually.

Charlotte Foust

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