Unanswered: Need one report based on any one of many queries
I'm using Access 2007. I have a large report that I need to let the user select which test subject to base the report on. Then based on that test subject, I need the report to pull data from the specific query based on that subject. I need to know how to code the fields in the report to accept the data based on the subject requested. I know how to create an if statement that changes a field in the report to display certain data. I have six different subject choices and each subject choice as 25 different fields associated with that one subject. I have queried each subject. Then I thought I could combine all the subject queries into one query and create a pop-up box that ask for which subject. My question is how to do I place the query name in the field source on the report?
Typically, you have that kind of code in the On Open event procedure for the report (inside the report) or in the On Click event procedure for the "proceed" button on the reporting dialog box (outside the report).
How would I identify the source in the individual field on the report? Right now I have the field names for the Science Test fields in the report. Each Subject has its own field names - 25 fields each. Example ScienceAccom1, ScienceAcomm2... for each subject Math, Social Studies etc... What field identity do I put in the layout of the report itself?