todays date in table field when form is updated 1

[skaurd]

HI

How would I get my form to add todays date and the time when a user updates the data?

many thanks

S

 

[papparuff]

In the form's Before Update you can use this code:

If me.dirty then
Updated=Now()
endif

Updated is the field in my recordsource that has the date and time an update was accomplished on the current record. If any changes are made to a record the Dirty property of the form becomes true. John Ruff - The Eternal Optimist

 

[skaurd]

HI JOhn

I tried this but I get an error message when I try to edit any data;

Compile error
Block if without if

many thanks

Sukhi

 

[papparuff]

Let's look at your code please? What is the name of the field that is going to store the Date the record is updated?
John Ruff - The Eternal Optimist

http://www.noclassroom.com

 

[skaurd]

John

Sorry false alarm - it worked just fine (after I typed it correctly (duh))

many thanks

S

 

[skaurd]

Sorry John

It worked fine on one of my forms, but ot doesn't work for another which has a sub form combo list (which you can open the form with if you selelect a particular record

Code is like so;

Private Sub Form_BeforeUpdate(Cancel As Integer)
If Me.Dirty Then
last_updated = Now()
End If
End Sub

thanks

S