Repetitie parameter requests

[FoxGolfer]

First, Access newbie.
Second, I have 5 tables, all of them contain a common field, Order#. I created a report that has the main table and 4 subreports based on data from the 5 tables. When I ask for a report based on one order, it asks for the same parameter 5 times. Any ideas?
Thanks in advance.

 

[TomCologne]

Your report is probably supposed to display something that Access can't find.

This can be caused by typos, renamed or deleted fields etc..

What parameter are you being asked for?


TomCologne

 

[FoxGolfer]

The OrderNo, which is the order number. The field exists in every table. There are queries to feed subreports and they all have [Enter Work Order Number] as the criteria in each query. That explains the repetitive request for a parameter, right? But if I don't have the parameter in the query I don't get the data for each order, I get ALL the data. I do have the correct relationships established but I'm thinking it's a query construction problem?
TIA,
Tom

 

[TomCologne]

Having the OrderNo as criterion for the qry that's behind the main report should be enough, assuming that the subreports are linked to the main report by OrderNo.

You then need to enter a number once and that's it.

Try that and see if it works.

A more practical approach than the parameter dialog is using a form to select the OrderNo and open the report.

In the query you will need to change

[Enter Work Order Number]
to
Forms!frmFormNameXYZ!ControlNameXYZ


TomCologne

 

[FoxGolfer]

Ok, I tried the first approach and I deleted the [] parameter request in each query for each subreport and ensured that each subreport was linked to the main report by the OrderNo. Now, it asks only twice? Close but no cigar. I'm sure I'm missing something.