Stop 'Enter Parameter Value' after cancelling

B

Brad

Hi,

Does anyone know how to stop the 'Enter parameter value'
box from coming up after you cancel a form, which is
providing a means for entering criteria for a report. The
cancel button closes the form and event, but this little
box remains!

Thanks
Brad
 
L

Larry Linson

Easy... find some way to do what you want to do other than using Parameter
Queries. If you use an SQL string with a WHERE clause (write the SQL
yourself, or copy it from a Query you build with the Query Builder), and it
can be directly executed from code, used at the RecordSource for a Form or
Report, or stored into the SQL property of a saved Query.

Larry Linson
Microsoft Access MVP
 

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

report still looks for parameters when parameter form is cancelled 5
display reports with parameter form 1
Enter Parameter Value in Access Form 0
Enter Parameter Value? 4
Automatically Enter Parameter Value 2
Cancel query that runs report from form 1
"Enter Parameter Value" box problem 8
"enter parameter value of table" 8

Top