can't get time stamp to work

K

KittyS

I have a form that has a change date on it: xChangeDate, which I want
stamped with Now() when I change anything on the record. I have code
that reads:

Private Sub Form_BeforeUpdate(Cancel As Integer)
xChangeDate = Now()
End Sub

but when I change a record, nothing at all happens. I had similar code
in another project that worked fine. What could I be doing wrong?

Thanks
Kitty
 
S

strive4peace

Hi Kitty,

perhaps it IS working... you just may not see the change
right away. Try putting

DoEvents

after the assignment

Have an awesome day

Warm Regards,
Crystal

MVP Microsoft Access

remote programming and training
strive4peace2006 at yahoo.com
 
Top