popup box

[slimjen1]

All. I have a cmd button on a form that when the users click, they get a message box to enter some criteria. The buttons record source is a query. How can I get it so when the user click the button instead of the message box to enter data, they get a drop down box to choose criteria? I know that I can create a combo box on the form and put code behind the button but I'm trying to eliminate too many boxes.
Thanks

 

[jkl0]

You can't do it with a message box, but you could use a pop up form with a combo box to accomplish the same thing.