Query in a form

**Csalge** · 03-27-2013, 02:29 PM

I have a parameter query running in a form as a source object. Everything works fine except that whenever I run the form it asks me for the parameters twice. It works fine but i wonder how i can stop that. When i run the query directly it only asks for parameters once but when i open the form it asks for it twice. What shoud I do to avoid the double entry of parameters?

**pbaldy** · 03-27-2013, 02:43 PM

I would use a form for the user to enter the parameter and have the query get it from there.

**June7** · 03-27-2013, 03:05 PM

I agree, I never use query input popups. I avoid dynamic parameters in queries and use code to set filters for forms and reports. However, review http://datapigtechnologies.com/flash...tomfilter.html

**Csalge** · 03-28-2013, 01:12 PM

Great. I did that and it worked fine.

**pbaldy** · 03-28-2013, 01:46 PM

Happy to help!

Query in a form

Thread Tools

Query in a form

Similar Threads

Set a query filter from a control on a form then launch a report from that query

Enter the value in the form and show results (sort of like query but not query)

In a form, how to query a table to count records between dates entered on form

How to Use Search Form Query Result & GoTo Desired Record on Separate Form

Adding Count Query to Select Query Causes Blank Screen In Subsequent Form

Posting Permissions