I created a dialog box to allow a user to enter a name into in order to filter data in the report that opens, following guidance in ComputerPREP's Access III Student Guide. I guess they didn't want to go into VBA in this guide, because this is the workaround for the default "Enter Parameter Value" dialog box pop-up:
In the macro, they give guidance to close the current "filter" dialog box , and simply create another MsgBox that will prompt the user to click cancel in the next "Enter Parameter Value" dialog box.
I guess a macro doesn't have the possibility of preventing the default dialog box from displaying.
Can anyone help me with a general VBA script to prevent the default dialog from displaying, which I can reference in the same macro to 'RunCode' rather than displaying the MsgBox?
In the macro, they give guidance to close the current "filter" dialog box , and simply create another MsgBox that will prompt the user to click cancel in the next "Enter Parameter Value" dialog box.
I guess a macro doesn't have the possibility of preventing the default dialog box from displaying.
Can anyone help me with a general VBA script to prevent the default dialog from displaying, which I can reference in the same macro to 'RunCode' rather than displaying the MsgBox?