Topics Search

Print report based on current form open

Print report based on current form open
Views: 28
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...


have a report print from current record

have a report print from current record Icon
We have quite a large split multi user database. It is utilised by a number of forms.

What I would like to do is create a report that outputs a page based on the details of a current record within a form. IE I would like a button on the form, lets say Print WIP and it run and print the report for the current record only.

I know how to create the query with the information, and build the report based on the query. My question is, how do I get the query to only pull the data from the current record

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 from Form ID

Print Report from Form ID Icon
I created a query for the report to pull the information from the current form record but can't get it to work. In the query under criteria I entered this:
=[form]![SAE PHO VA FORM]![ID]

The form gets it's information from a table where I also enter new information to create a new record.

The query works but when the form is open and I want to print that current form record from a command button to a report it asked for a ID. It should pull the current form ID (record) without asking me for the ID.

This works in all versions but Access

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.

Printing report from Form

Printing report from Form Icon
I am able to print a report of all records from a command button on a form with

DoCmd.OpenReport "General Input Info", acViewPreview

I can also print just the current form to the report with

DoCmd.OpenReport "General Input Info", acViewPreview [ID] = & [ID].

What I would like to do is print a report showing the current form and all the forms after that form. In other words, none of the records previous to the current form listed but do show the current record and all others after that as determined by the auto number ID field. I am able to filter by form in the ID field with >45 showing me all records with an ID of 46 and above but I want to be able simply print the report from the command button that is on the form.

Printing wrong Form / Report

Printing wrong Form / Report Icon
I have a typical form for user input which, from a button on the form, fires up a report in Print Preview. When I then try to print the Report (just using the standard Print Icon in Access), it prints the Input Form rather than the Report, eventhough the Report has the focus.

When I close the form so that the only window open is the Report, then the Access Print Icon grays out

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

Limiting a report to shown a single record from form

Limiting a report to shown a single record from form Icon
I have a form/subform combination on my database.

One record on the subform can relate to several records on the subform, i.e

Record 1, has five incidents on it so records in the subform are 1.1, 1.2, 1.3 etc.

I then need a print off of these in report format, I only need a single record for the report though. The issue I'm having is that all of the records are printing on the report! Is there any criteria I can state to print the current form? I know I can create a form button to print current form, but I need the report format

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