CODEWITHSUNDEEP
ms-accessvbams-access-data-macro
0014
0014

Reputation: 933

Ms Access Data Macro Return Record Set

I am using a Data Macro for one of my Access table's after insert event. Inside this Data Macro, I am using SetLocalVar to call one of my functions written in vba to insert the same inserted record set into my SQL Database. This is how the Expression in SetLocalVar currently looks like;

AfterInsertMacro("TblLotStatus",[LotStatusID], [NextStatus], [Status], [Printed], [Active], [AvailableForPull] )

Now, instead of returning back every column as a separate variable, can't I return a record set or a collection or an array etc. ?

Basically I am looking for something like this (written in C# language);

AfterInsertMacro("TblLotStatus", new object[]{[LotStatusID], [NextStatus], [Status], [Printed], [Active], [AvailableForPull]} )

Or any kind of expression that would look like;

AfterInsertMacro("TblLotStatus", [Inserted Recordset])

Upvotes: 0

Views: 436

Answers (0)

Related Questions