Update Field on New Record Added

C

CK

How do I check that a new record has been added instead of an existing record
being edited? I have a userid field to track the user who created records but
not to users who edit records. On a form, what would be the correct event to
trap in order to update the userid field with the CUrrentUser() function?
Thanks.
ck
 
A

Allen Browne

Use the BeforeUpdate event of the form, and test its NewRecord property to
determine if it is a new record or and edit.
 
Top