I just bought this lesson. I am a new Gold member. The reason I bought it was I assumed I could differentiate the difference between adding a new record vs. updating an existing record. I tried to use the IsNull of the AutoNumber field in a Before Update data macro but it didn't work. Apparently this macro has already knows the AutoNumber even though it is a new record and hasn't been Inserted yet.
Joe Holland
@Reply 2 years ago
Use NewRecord property to determine if a record is new and not added to the table yet. See https://learn.microsoft.com/en-us/office/vba/api/access.form.newrecord
Kenneth StevensOP
@Reply 2 years ago
Your solution is a form property and not a Data Macro property which works with the Table regardless of how many forms may be involved with the table. I wanted to know the difference between a new record and a changed record at the Table level. Thank you though.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Advanced 6.
