1

MS Office 265 ProPlus, Access 2007 - 2016

While defining a "Before Update" macro(?) on a table, I'd like to be able to detect when this is an update to an existing record vs inserting a new record.

I know about and have used the "Old" context tag/prefix in other cases. In this case I guess "Old" wouldn't exist or be undefined if this is an insert. Is there a way to detect that? Is there some other way?

Thanks for any help.

Santosh
  • 12,175
  • 4
  • 41
  • 72
daveg
  • 1,051
  • 11
  • 24

1 Answers1

0

Are you referring to Before Change table event?

enter image description here

Use the IsInsert property to determine whether the Before Change event was triggered by a new record being created or a change to an existing record

Community
  • 1
  • 1
Santosh
  • 12,175
  • 4
  • 41
  • 72