Can't get ID after CreateRecord in Access 2010 Web database macro

[mkenyon2]

First off, this is an Access 2010 Web Database, so I can't do VBA code. I have to use this stupid macro editor.
I do CreateRecord (Alias 'Build') with a SetField (Build.Asset, [NewAssetID])
Then I do SetReturnVar (BuildingID, [Build].[ID])

The record gets created in the table, but the SetReturnVar errors.

Error is [Build] could not be found.

I've also tried the tablename, and just the column ([ID]), all give the same error, cannot be found!

Also tried LastCreateRecordIdentity and got 'LastcreateRecordIdentity': cannot find item.



Umm... why?

[mkenyon2]

Ahh... I need to use [LastCreatedRecordIdentity] by itself. Not [LastCreatedRecordIdentity].[ID]. Glad the documentation is so clear on this. (Oh, wait, what documentation.)