Topics Search

Print report based on current form open

Print report based on current form open
Views: 31
I created an order entry database for some users at work. I created a main form that has customerName, customerAddress, zip, state which drives an orderID and orderDetails table. I have a subform attached that shows Item#, Description and Qty.

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?
Sponsored Links:

Similar posts...


Logic statement to select report

Logic statement to select report Icon
To simplify my reports, I am planning on making three reports that will all differ to print data from the same form. This is due to some reports needing features that others will not. Whenthe user clicks print on the form, I only want one of the reports to print though.

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.

Printing current form record

Printing current form record Icon
I have a form that lists job orders for a given day that I enter myself, and then I have a print button with the following code


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.

Print report currently viewing on a form

Print report currently viewing on a form Icon
I have been trying to solve this ALL DAY and I am no nearer to solving. I have a report, built from a form. I want to print a one copy of the current record I am viewing, in my form, if I create a print button it wants to print out all the records in the report. I just want to print what I am viewing.

Button currently prints ALL records instead current one

Button currently prints ALL records instead current one Icon
I have created a form using Access 2010 and added a button using the command button wizard so that it prints the report I made. It is printing all the records, but I only want to print the the current record.

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...

Print reports with creteria ..

Print reports with creteria .. Icon
Access 2003, vista. I have a form, which contains a series of filter and sorting criteria in order to create a work plan for an employee.

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). ?

Button on form to print report for current record

Button on form to print report for current record Icon
I want to put a button in my input form so it can print a report looking at only the current record I am in using2007.

See names below:

Input Form: CC Form Entry
Unique Field: CC Number
Report: Customer Complaint Form

Pass Subform filter to subform in report

Pass Subform filter to subform in report Icon
I can't seem to figure out how to pass a filter from a subform to a subform in my report so I can open the report in print preview to print.

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
End Sub

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.

Trying to print current record

Trying to print current record Icon
I have a form that I created a button (that activates a macro) to print the current record (so I thought).
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).

Print vs. Print Preview

Print vs. Print Preview Icon
I am adding a report to an Access 2007 Db that will end up being a Runtime version. On the switchboard (actually a form I'm using as my switchboard) I have a button to print this report.

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.

Printing report crashes access

Printing report crashes access Icon
I have a form that once filled in, I have included a print button that filters the form for the current record and produces a report in print preview. This print preview always works, but when the user clicks the "print" button on the ribbon--about 1/2 the time, access crashes.

Access has to be reopened and the report located to print again (embarrassing in front of customers waiting on their invoice).