Run-time error "3892"

Question

"The function "|" is not valid for expressions used in data macros"

I'm new to data macros. I have all forms and scripts contained in a front end ACCDB.  Data tables contained in a linked back end ACCDB.

I just created a simple data macro against a table in the back end.  All it does for now is run MsgBox if the record is modified.

If I manually modify a record in the back end, the data macro works fine.

However, If I use the preexisting front end forms to modify a record in that table, I get the 3892 error.  Removing the macro, the error goes away.  Nothing in my macro uses "|".

The error is triggered on the following pre-existing line of code in the front end.

   RunCommand acCmdSaveRecord

thanks

Answer 1

Data macros have no UI, because they run in the data layer and there may be nobody to observe it. Below screenshot shows the available macro actions. Stick with those.