Auto date for revised records

  • Thread starter Thread starter Marguerita
  • Start date Start date
M

Marguerita

Hello all,

I have a database which I use for document tracking. It
is now recommended for use by all. I have two date fields
in the form. 1) When the document was received, this they
can input themselves. 2)An update date, when additional
information is supplied at a later time. I manually enter
this. Now that it will be accessed by many, to maintain
consistancy in the process, I would like to have this done
automatically. I have tried setting the form's
BeforeUpdate event to Now...with no luck. Could some one
assist me as to where or what I am doing wrong?

Thanks

M~
 
I don't see why that wouldn't work. The code seems to work
alright in my document control database.

Private Sub Form_BeforeUpdate(Cancel As Integer)
Me.[ReviseDate] = Now()
End Sub

I would suggest to have the field locked.
 
Thank you. I found my error. I put coding in the event
of the field not the form. I have been at this too long
today. Thanks again for you time.
-----Original Message-----
I don't see why that wouldn't work. The code seems to work
alright in my document control database.

Private Sub Form_BeforeUpdate(Cancel As Integer)
Me.[ReviseDate] = Now()
End Sub

I would suggest to have the field locked.
-----Original Message-----
Hello all,

I have a database which I use for document tracking. It
is now recommended for use by all. I have two date fields
in the form. 1) When the document was received, this they
can input themselves. 2)An update date, when additional
information is supplied at a later time. I manually enter
this. Now that it will be accessed by many, to maintain
consistancy in the process, I would like to have this done
automatically. I have tried setting the form's
BeforeUpdate event to Now...with no luck. Could some one
assist me as to where or what I am doing wrong?

Thanks

M~
.
Click to expand...
.
Click to expand...
 
Back
Top