Filter from form to report (1 Viewer)

[georg7]

Good morning guys,
I've my form where I get my data from my query. on the form I set a filter to select my wanted data(red circle). Is it possible to get the filter to my report that I can print it ? Printing forms is just annoying and it Looks Pretty ugly.

Or are there other ways to get the printed form more like "high quality"?

Appreciate your help!
Best regards georg7

 

[isladogs]

Yes. You can filter reports in exactly the same types of ways as you filter forms.
For example you can use a 'where condition' in your report record source based on the form filter value.
See DoCmd.OpenReport method

Or you can use the OpenArgs property

 

[georg7]

I tried the DoCmd.OpenReport method but I won't work.(you can see it on Code.png)
It always prints the full form data not the datas that I've filtered.

 

[CJ_London]

looks like you have a form/subform arrangement with the button on the main form, so your code (which for future reference and clarity, please copy/paste to the thread using the insert - code option on the post ribbon) needs to be something like

docmd.openreport "myReport",,,mysubformname.form.filter

 

[isladogs]

Georg
You used the filter name argument NOT the where condition.
As CJL siad, something like this should work

DoCmd.OpenReport "ReportName", , , "FieldName = '" & Forms!FormName.ControlName & "'"

 

[georg7]

Thank you guys for your help but I don't mean the tipical filter. In Germany this(Picture) is also called a Filter but i think ist more like a select.I can pick the data that I want and the rest will be hidden.

I think that there is no way to get it to my report?

 

[theDBguy]

Thank you guys for your help but I don't mean the tipical filter. In Germany this(Picture) is also called a Filter but i think ist more like a select.I can pick the data that I want and the rest will be hidden.

I think that there is no way to get it to my report?

Hi. Have you tried what CJ suggested? Just curious...

 

[CJ_London]

your picture shows one of the ways that records can be filtered from a datasheet, as you tick and untick it updates the filter property. If you were to right click on one of the fields below you will get other ways of filtering.

It is now not clear to me what you want - you originally said you wanted a report based on the filter of the form which is perfectly doable as already explained. What you now seem to be asking is how to get the filter creation functionality of a datasheet into a report. To do that, you would need to use a datasheet subreport (create your subreport control on your report, and populate the sourceobject with Query.myQuery or Table.myQuery or Form.myForm (where myForm is a datasheet).

 

[georg7]

Thank you CJ!
I'm really sorry for the misunderstanding.
I appreciate your help.
I think my Access skills are not good enough to create something like that because I'm a newbie.

 

[CJ_London]

no problem, happy to help. Good luck with your project

 

[MajP]

@georg7
This does what you want and the code is simple