(This is a follow-up to an answer from an earlier question here.)
I have an Access 2010 database file containing a table with a Before Change
Data Macro:
I can open the table in Datasheet View and add rows, and the Data Macro behaves as expected. However, if I open the table in Design View, open the Data Macro for editing, do something trivial like click the [+] beside one of the macro steps to expand the details, and then try to save the "changes" I get the error
The 'LookUpRecord' macro action has an invalid value for the 'Look Up A Record In' argument.
I have also tried to create the macro from scratch in a fresh Access 2010 .accdb
and get the same error. I have tested this on three different machines: two machines running 64-bit Access 2010 and one machine running 32-bit Access 2010. All machines are fully patched via Microsoft Update. (That is, they are currently running version 14.0.7106.5003.)
While testing I noted that this appears to be related to an event-driven Data Macro trying to use LookUpRecord
to perform a SELECT on the same table to which the Data Macro applies. Performing a SELECT on some other table does not seem to trigger the error.
My questions are:
Can anyone recreate this issue with a patched version of Access 2010?
Can anyone test this with an unpatched version of Access 2010 (e.g., fresh install from an early release) to see if a subsequent patch
brokechanged something?Has anyone seen any documentation or Internet chatter to suggest that an event-driven Data Macro for a particular table should (or should not) be able to do a
LookUpRecord
by performing a SELECT on itself?
Edit -- 2013-12-19 14:10 UTC:
I just tested this with Access 2010 SP1 (14.0.6023.1000) and got the same results.