Using an Access form to enter parameters for a Query

G

Guest

I have a query with 4 parameters that feed a report. I have made a form with
combo boxes with the criteria for each of the parameters and have it set to
open when the report is opened. When the criteria is set for the parameters
and the enter button is hit the criteria doesn't feed the query it will still
pop up 4 criteria boxes. I have the following formula entered in the query
field criteria
[Forms]![Form Name]![Combo Box Name On Form]. this is the exact same format
as that the Office Help page showed. Can someone tell me what I'm doing
wrong or missing. I even down loaded the example Access file and made my own
query, report and form that mirrored the ones that worked and I still
couldn't get this work.
 
P

pietlinden

remove the parameters from the query.
Create a filter (valid SQL Where clause) and pass that in the Open
event of the report. Makes the report MUCH more flexible.
 

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

Multiple Parameter Crosstab query filter by form 1
Parameter Query Won't Run 0
Using a Form to supply parameters to a query 13
Multiple Queries / Same Criteria 3
Sources for query parameters 10
How do I set up query to look for parameters in a form? 1
Query from unbound form 4
Expression for Criteria for Form with Combo Boxes 1

Top