Access Keeps Asking for Parameters

[italianfinancier]

I created a report that generates via several queries after a user enters a customer number and clicks a button. The problem I am having is that instead of just running, Access asks for each parameter to be entered individually by the user. I set the queries up with criteria so that just the data on the customer number entered by the user displays. How do I get Access to just plug the number entered by the user into all those parameter dialog boxes?

Any help would be great!

 

[Beetle]

I created a report that generates via several queries...

Why several queries, rather than just one? Do you have sub reports? Is there something else complex about this? Even if you do need several queries, they shouldn't all have the same parameter.

Have you tried removing the parameter to see if the report successfully returns all records?

How is the user entering the customer number? In a form? Is the form remaining open when the rport is run?

 

[italianfinancier]

I have several queries because the data is in different tables and is unrelated. The parameter I used is customer number and I did that for all the queries. When I run just the queries individually, they return just what is entered by the user...it is only when I run the report that the parameter boxes show up. The user is entering the customer number into a form.

THanks for your reply and I look forward to your next!

 

[gemma-the-husky]

look at the query properties. if you copied/renamed the query, you may find the culprit is a sort order parameter, with the previous query name.

 

[themurph2000]

look at the query properties. if you copied/renamed the query, you may find the culprit is a sort order parameter, with the previous query name.

I'm having a similar problem, since I renamed two of the fields to not have any spaces as I needed them as part of some VB code. However, the query doesn't ask for the two fields in question; the corresponding report does, and I checked every field and the sort/group setup. Any other suggestions for places to look?

UPDATE: Never mind. Found it. Kudos to BobLarson and his VTools suggestion.

 

[dbaldwin]

I have had similar difficulties in the past. If you have changed fields, names, properties, etc... I have found it necessary at times to reenter the field in the query, and again reenter the field into the report. If the Report is grouped on the field(s) in question, you should see if the grouping is still configured properly. I once found that I had to reselect the field to be grouped on.