Richard,
Love your videos and the "access" to your knowledge through this forum.
I have built a Parameter Query Form that I made a command button for on a "main menu" form like you created in your videos.  I noticed one weird thing that happens that I spent 3+ hours trying to resolve on my own before giving up.  The button works fine you get the prompt box for the value, but if you don't put something in and just hit "cancel" you get an error (#2001).  How do I get it to just close the form if the user just hits cancel?

Thanks in advance for any guidance!!
Jeff

---

Reply from Richard Rost:

That is a little more complex. You can solve this problem with an IIF function (to check for a NULL result returned) and by using a FORM to get the parameter, like I show in this tip: Get a Value from an Open Form Field.