Would like to hide and Automate a Parameter Message Box

[Liz_I3]

I am working with a parameter query. When my DB opens the form that is run opens the parameter query in hidden view. Of course the message box comes up to Enter Parameter Value. I have set the query so that if no value is entered all are shown. My question is when the DB is open and the Message box come up I want to code it (in VBA) so that when the Enter Paramenter Value is displayed the OK button to be pressed so the user does not have to do it. Actually it would be good if the message box was not visable at all. Is this Possible?

would be grateful for any assistance

Thanks Liz

 

[Ziggy]

Liz Clarify your question, The last sentence threw me off...you want code to press OK on the parameter??


But throughout your question it sounded like all you need is to put a static criteria in your query....or

If you want VBA, you need a variable to take the place of the critieria so that you can pass it to the procedure. explain where you might obtain that value so someone can give you the example.

I just thought I'd bump your post back up.

Ziggy