[AccessD] Before update problem

Doug,

What exactly do you mean by "doesn't work"?  QuoteDate field does not 
get updated? Error message? Crash? Something else?  I would expect it to 
work as you have it (well, I would expect the ()s to be removed in the 
code).   What happens if you try like this:
  Me.QUOTEDATE = Date

Regards
Steve


Doug Barnes wrote:
> 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