Cancelling out of parameter dialog box

S

Sue

I have a dialog box for entering three parameters for a parameter query which
is working fine. When the user hits the cancel button without entering any
parameters, they are still prompted for the first parameter through the MS
Access parameter dialog box. I used the DoCmd.Close with the on-click event
for the cancel button. (I tried some other ways but they too didn't work).
Thanks for any help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Task Information Dialog Box not making duration changes to task 0
Word OLE to check spelling in text box 1
Check Box query issue 3
Why does query execute before OnLoad event of Form 7
cancel button to stop report 6
Creating a Search using a combo box and then creating a report. 4
Parameter Dialog box 5
Weird "Parameter Request" 12

Top