Print report based on current form open
I need to make a print button that will print a report based on the information the user entered. How do I make the button print a report based on the current data in that form? Do I usethe forms sql code as the forms control source?
Thank you for taking the time to report an issue.
What's wrong... Please write below.
The report would be selected based on the current record set pulled up in the form. I.E. if that record set contains a number 5 then print report 1, a number 7 then print report 2, or a number 9 then print report 3.
I have the form and report printing fine right now when I reference the report directly in the macro and switch it out for each report.
I tried setting up a Macro with Open, Print, Close commands for each report with conditional statements defining which form to select. It seemed it only looks at the first record in thedata set it is printing and makes the call then moved to the next command which dosent work.
I have made a report that will print the current record based on the "ID" field. this sort of works except for the fact that when I type in my jobs, and click the print button it just prints a blank report, but if I close the form and then reopen it and go to the record I want and click print, it works fine.
is there any way to remedy this and just click print, instead of having to reopen the form.
The form and the report are picking up from several tables if that makes a difference. How do I get it to only print the current form/record not every one? I want the layout as per my report...
The filter and sorting criteria form a report with the work plan for the employee.
I need to print, from the form, all the reports that relevant for the work plan. The reports are separated and can differ from one another in their structure and name.
I have 2 questions – 1st each print opens the specific report (because they differ I need to open then one at a time and not as a whole batch), print it, and then close it. In a workplan of 200 reports this procedure is very slow,
2nd – The list of reports are based on a basic query that uses dates as a criteria, and from the form itself I send 8 more filter possibilities, and a sorting preferences. How do I print the list that the criteria in the form represent? And how do I send the printout in the same order as should be in the report (so the user won't have to set the order of the report each time he produces a work plan for the current month). ?
See names below:
Input Form: CC Form Entry
Unique Field: CC Number
Report: Customer Complaint Form
I have a Main form (Summary) that includes a subform (SummaryQuerySubfrm) which are linked together by ID.
I have a combo box on the main form which filters the subform by using the code below in the after update event of the combo box.
Private Sub SummaryMonth_AfterUpdate()
SummaryQuerySubfrm.Form.Filter = "[SubformField]= '" & ComboBox & "'"
SummaryQuerySubfrm.Form.FilterOn = True
I want to be able to print the current main form and the filtered subform the user has selected via a report (Print preview).
I am not sure how to pass the filter from my subform on my main form to the subform on my report.
At the moment when I select the print button on my main form, it brings up the print preview of the report however it does not filter the subform within the report.
Here is the action:
Report Name: DOA Record Report
View: Report |
Filter Name: -----
Where Condition: [ID1]=[Forms]![App 1]![ID1]
Window Mode: Normal
ID1 is the primary key on the form
App 1 is the name of the form.
I would have just used the PRINT RECORD button that's built in, but that's another problem (error popups).
Here's the problem. When I click the button to print the report, it opens the report in "Print Preview", but I'm seeing a blank report and a Print window. if I click on "Print", the report prints AND I get to see the Print Preview.
However, if I click on "Cancel", I am allowed to see the Print Preview, but have then lost theability to Print.
What I was hoping was that the Print Preview would open so my users might decide if they wish to print or cancel.
Access has to be reopened and the report located to print again (embarrassing in front of customers waiting on their invoice).