Filtering data in reports and subreports

[MikeDNova]

Hey guys hows it goin??

I'm almost done with a project and need a little help to wrap it up!

I have a master report with about 7 subreports. I prompt the user for an InspectionID when they open the main report. Each of the 7 subreports is based on a query for a different datatype and I also select the InspectionID. I have a field QuestionID that I already use to link the master report to the child reports so that they are listed in order. Now everytime I open the reports it prints out subreports for everything, not just the one InspectionID that i want. FOr instance, If the user enters 1 as the InspectionID when opening the main report, i only want subreport/fields listed whose InspectionID is 1. If this makes any sense to you please help me out. If you need more info just ask!

Thanks again guys!!!
-Mike
Mikednova@hotmail.com

 

[RSi2]

another way to impose your ID is to make a form where u enter the ID (which will be stored in a variable in a Module)
And in all your queries put : WHERE ID = GetMyID()
with GetMyID a public function in your module giving you the stored ID

 

[MikeDNova]

ok thanks a lot, thats what i ended up doing!!