Checking for new record

[John]

Hi

I need to validate a field in after update but only if it is a new record
and not an exiting record. How can I check for a new record in after update
event of a field?

Thanks

Regards

 

[Rick Brandt]

Hi

I need to validate a field in after update but only if it is a new record and
not an exiting record. How can I check for a new record in after update event
of a field?

If Me.NewRecord Then...

 

[Guest]

For validation purposes the form's BeforeUpdate event procedure would be
better as this has a Cancel argument whose return value can be set to True,
e.g.

If Me.NewRecord Then
If Not <validation criterion> Then
MsgBox "Your Message", vbExclamation, "Warning"
Cancel = True
End If
End If

Ken Sheridan
Stafford, England