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.
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
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.
=[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
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.
When I close the form so that the only window open is the Report, then the Access Print Icon grays out
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). ?
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