Not sure what you are asking ... I will take a guess
you can use the BeforeUpdate event to test whether a record is added or changed:
If Me.NewRecord Then
This event happens after the record is filled out, just before it saves
Alternately, you can use the BeforeInsert event, which I normally do not use since it happens just as a new record is getting created.
here is jump to a spot in a video that talks about updating tracking fields:
Warm Regards,
Crystal
~ have an awesome day ~
On Tuesday, December 23, 2014 2:00 PM, "kenaf42@yahoo.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:
Access 07, I need the code for today's date on a form that would execute only when form is in ADD Mode.
Please help.
__._,_.___
Posted by: Crystal <strive4peace2008@yahoo.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar