Update Field on New Record Added

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Use the BeforeUpdate event of the form, and test its NewRecord property to
determine if it is a new record or and edit.
 
Back
Top