Date stamping a form/record

[Ricter]

I'm using a field on the mainform called RecordDate, default value =Now(),
and the mainform's Before_Update event code is

RecordDate = Now()


The situation is that when I move to a new record the above is working fine,
but if I immediately back up one record, the previous date/time is being
updated to the current date/time. Backing up still more records does not
change their date/time.

What is the reason for this please?

 

[RuralGuy]

I'm using a field on the mainform called RecordDate, default value =Now(),
and the mainform's Before_Update event code is

RecordDate = Now()


The situation is that when I move to a new record the above is working fine,
but if I immediately back up one record, the previous date/time is being
updated to the current date/time. Backing up still more records does not
change their date/time.

What is the reason for this please?

If Me.NewRecord Then
RecordDate = Now()
End If
_______________________________________________
hth - RuralGuy (RG for short)
Please post to the NewsGroup so all may benefit.

 

[Ricter]

That worked, thanks RuralGuy!

If Me.NewRecord Then
RecordDate = Now()
End If
_______________________________________________
hth - RuralGuy (RG for short)
Please post to the NewsGroup so all may benefit.

 

[RuralGuy]

Glad I could help.

That worked, thanks RuralGuy!

_______________________________________________
hth - RuralGuy (RG for short)
Please post to the NewsGroup so all may benefit.