"Microsoft Access can't find the macro"

[JerSand]

I've designed a simple application in which users are getting a message I haven't seen before. Sometimes, a user is a poor marksman with the mouse and clicks in the area of a form that -- in design view -- is the detail area. The text in the popup is: Microsoft Access can't find the macro ''.'

The popup continues with this explanation: "The macro (or its macro group) doesn't exist, or the macro is new but hasn't been saved. Note that when you enter the macrogroup.macroname syntax in an argument, you must specify the name the macro's macro group was last saved under."

The popup box has an "OK" button. When the user clicks on it, the popup goes away, and the user can continue as if he/she had not accidentally clicked outside a field. The forms are recording the data to the tables accurately.

I'm an Access simpleton in that I do not know VBA. I make-do by attaching simple, four- or five-argument macros (I don't use macro groups) to command buttons. The command buttons are working fine.

I'd be grateful for an explanation or hypothesis about why the popup is appearing and -- even better -- suggestions about how to make it stop.

Thanks.

JerSand

 

[PHV]

Check all the OnXXXX properties of the detail area for misspelled macro name.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244