Access 2000 - Report for 2 Tables

[volaris]

I have two tables that have no relationship except for the Activity field. I needed a report that would print all records for the 2nd table right after all the records of the 1st. I created 2 querys on the two tables for the info I needed. In the report design, I put the 1st table/query info in the detail section and put the 2nd table/query info in the report footer as a subreport. This worked great! But my problem is that they liked this report so much, they want a separate one for each Activity. When I initiate the report, I need to enter the number for the activity and have it print out only that data. When I put the "Enter Activity Code:" selection in the query it asks for it 5 or 6 times when I initiate the report and doesn't give me any data for the 2nd report. My question is how do I set it up so when I initiate the report, I put in the Activity code once, and the report displays the 1st query data for that activity and immediately following that data it displays the 2nd query data for that same activity. I have tried everything I know. I hope someone out there can help.

Thank you,
Volaris

 

[cghoga]

To enter the code once, enter it on a form, then point your query parameter to the value on that form.