[AccessD] Before update problem

Doug,

    Nothing wrong with your code. Apparently it is in disabled state, typical when Access 2007 file opens.

    On opening the file, just make sure that you enable the "potentially harmful content" in "Security Alert" dialog box, invoked by clicking "Options" button in the "Security Warning" message.

Best wishes,
A.D.Tejpal
---------------

  ----- Original Message ----- 
  From: Doug Barnes 
  To: accessD at databaseadvisors.com 
  Sent: Wednesday, June 13, 2007 23:49
  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