Print and current set of record wit existing query

DevAccess

Registered User.
Local time
Today, 15:49
Joined
Jun 27, 2016
Messages
321
hello

I would like to print current set of record which is display in form but want to use existing report which in turns uses query which is taking form input for query filtering.

Now how do I can take same report reference keeping in mind i may have different parameters this time as I have to take parameters from current form and query which is there on report is using different form parameters

How still I can use same report for printing purpose with different form input.

Can I copy same report or query or both and refer them ?
 
If you save the query the form is based on you can then use it as the record source for the report.
 
don't know how your form works but if you are filtering the data in the form, either manually or through the use of text or comboboxes and you have a 'open report' button on the form you can pass the filter on your docmd.openreport command

docmd.openreport "myreport",,,me.filter
 
don't know how your form works but if you are filtering the data in the form, either manually or through the use of text or comboboxes and you have a 'open report' button on the form you can pass the filter on your docmd.openreport command

docmd.openreport "myreport",,,me.filter

In my query, I have parameter from specific form, and that query is binded to a report, now I want to use same report but with different form as input then what is specified in report bound query.. how still I can use same report with different form input.. or I can copy those query anf report and modify that query to take parameter from new form.
 
Pass the the calling forms name as an openargs to the report, you can then change the recordsource for the report you want to use dynamically depending on which form calls it.
 
@Minty I can see the OP is not looking at my posts so I'm going to drop out - think you and I are on pretty much the same page anyway
 

Users who are viewing this thread

Back
Top Bottom