CreateRecord data block

Applies to: Access 2013, Office 2013

You can use the CreateRecord data block to create a new record in the specified table.


The CreateRecord data block is available only in Data Macros.


The CreateRecord data block has the following arguments.




Create a Record In


The name of the table to create the new record in.



An string that identifies the record. You can use the record's alias to identify


The record created by CreateRecord automatically becomes the current record.

After CreateRecord statement, you can insert a block of commands that will execute before the new record is committed. The following actions are available in a CreateRecord data block.

CancelRecordChange macro action

Comment macro statement

Group macro statement

If...Then...Else macro statement

SetField macro action

SetLocalVar macro action

After the CreateRecord action creates a record, use the SetField action to specify a value of a field in the new record.

You can use an If...Then...Else statment to perform operations based on a condition.

To cancel the creation of a record, use the CancelRecordChange action. This prevents the changes from being committed and exits the CreateRecord data block.

Once the new record is committed, you can use the LastCreateRecordIdentity local variable to work with the record. For example, use the following syntax to refer to the AssignedTo field of the most recently created record.


The CreateRecord data block can only be used in the After Insert, After Update, and After Update data macro events.