Unanswered: Dialog Box appears - Microsoft Office can't find the macro: Macro1
My forms are working fine, I was previously trying to use macro, but was unsuccessful and have used VB instead.
However, the following message appears in a dialog box:
Microsoft Office can't find the macro: Macro1
The macro (or its macro group does not exist), or the macro is new and has not been saved.
Note that when you enter the macrogroupname.macroname syntex in an argument, you must specify the name the macro's macro group was last saved under.
Any ideas as to where I would find the above, in VB, or properties or anywhere else.
This is one of the main reasons NOT to use macros. The event properties where Macro1 is specified could be those for the form, for the header, the footer or any label, textbox ... anything. You can't search for it, you have to go clicking everything to look for the event property with Macro1 in it.
Your absolutely right. After spending a day and a half looking for this macro, I stumbled upon it accidently. It was part of the background, which incidently looks like any other form in design view. Will nevery use macros again. Many thanks for your reply. Have a nice day.