Having small problem with running a macro

[Muzicmn]

I assume its a format error but what i am trying to do is run a macro which will open a pop up window if there are no records to display. Right now if the button us pushed and there are no records to display I get the debugger come up....

I created a small popup window alerting the user that there arent any records meeting his search and wrote a macro to open that form. But now i get the error that a macro name is needed. I have tried it several ways

ERR_FORM_OPEN:
DoCmd.RunMacro "mcronorecord"

or

ERR_FORM_OPEN:
DoCmd.RunMacro mcronorecord

or

ERR_FORM_OPEN:
DoCmd.RunMacro [mcronorecord]

none of which seem to work

would appreciate any help here

thanks guys

Ricky

 

[yellow]

If there are no records to display just show a message box saying there are no records rather than designing a new form and messing about with macros.