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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

rwop works 2
DMax on existing record to increment serialized # fails 1
Same form for new/edit record problem 4
blank form, can't insert new record 11
Update Form 1
Copy Field to another field in different Table 1
Auto update on combo form field 1
Separate Form 0

Back
Top