Is there a way for me to produce multiple reports off of one prompted query whether in a form or a report. I have 30 trucks in my database and I have 20 reports I run for them. I have each report set up using a prompted query, but now I want to enter the truck code once and have it print out all 20 reports. Is this possible?
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
That answer is a little above my head, so let me try and clarify what you said. In my reports form I should go ahead and create a combo box using the truckno as my field. Then under my existing report buttons insert a docmd for each report and it will reflect the truckno I have selected in my combo box even though my reports are run off of prompted queries?
Hi lebo2000,
Whole day today I was in Los Angles away from my home office that is why I could respond to you any sooner.
Task A: You need to put a combo box (cboTruckNo) on your form (not report). Have you done this? Do you need help on it?
Task B: If you open Report1 in design view and enter its first property (RecordSource), to the right ... will appear. Click on ... to get the record source query in design view. Locate field called TruckNo. Under this field in criteria section enter:
Forms!MyForm!cboTruckNo
When you run this report, its record source query (via Forms!MyForm!cboTruckNo) will limit data to truck number user selects using cboTruckNo on form MyForm.
Task C: After selecting a truck number using cboTruckNo, you need to click on a button (which you may already have) to run Report1 (from Task B).
Taske D: Save and run your form, select a truck number and run report. Does the prinout limit data to truck number selected earlier?
Task E: If the answer for Task D is yes, Aplly Task B to the remaining reports (Report2 through Report20)
Final Task: Sofar you had DoCmd.Print "Report1" under your print button click event. Add the rest of the report to it. Like in:
DoCmd.Print "Report1"
DoCmd.Print "Report2"
DoCmd.Print "Report3"
.
.
DoCmd.Print "Report20"
---------
Mike
Mike...Thanks for taking the time to help.
This what I did:
I created a new form called carrierspecific.
On that form I created a combo box called 4tlrcode with the 4ltrcode field from my carrierinfo table.
I also created a Reports button to take me to my reports form.
I select a button Inbound to go to my Inbound Reports.
I select the 1st Inbound Report I want to see with the 4ltrcode I selected in my combo box.
I changed the record source of that query to look like this:
forms!carrierspecific!cbo 4ltrcode ...do I need the cbo here?
I saved everything but I am now getting an error on my report when I view it.
It appears it is not getting that 4ltrcode.
Any suggestions?
This step is not done correctly
Task B: If you open Report1 in design view and enter its first property (RecordSource), to the right ... will appear. Click on ... to get the record source query in design view. Locate field called TruckNo. Under this field in criteria section enter:
Forms!MyForm!cboTruckNo
----------------
It sould look something like this (don't copy this, you have to make your own as described above):
Select Name, Amount , TruckNo .... From My Table Where TruckNo = Forms!MyForm!cboTruckNo ...
Business Accounts
Answer for Membership
by: eghtebasPosted on 2003-06-12 at 05:51:43ID: 8708198
Create a combo box (cboTruckNo) and refer to it by:
Forms!MyForm!cboTruckNo by replacing exiting criteria in your queries under field TruckNo.
Under button to print your the reports have
DoCmd.Print "Report1"
DoCmd.Print "Report2"
DoCmd.Print "Report3"
.
.
DoCmd.Print "Report20"