Not to open report. I want to do is I already created a query to filter data. Now i want when i click the button run the query and create report and preview itYou can use the Docmd.OpenReport method.
Ah, you don't have a report created yet? If so, try this button:Not to open report. I want to do is I already created a query to filter data. Now i want when i click the button run the query and create report and preview it
No Iwant make My own Button. When I click The Button I want to Run the Query and Save a report and Preview it
But why? I'm not sure I understand what you're trying to do? That's not a normal request. Can you tell us what you're really trying to accomplish? Maybe there's a better way to do it.No Iwant make My own Button. When I click The Button I want to Run the Query and Save a report and Preview it
Yes, if you create a report showing all the records, you can then open it with a filter. Review the link I posted earlier.Is there way to filter data in a report
NOYes, if you create a report showing all the records, you can then open it with a filter. Review the link I posted earlier.
Hi. The normal way is to create a report first, based on your query. You can then use a button to "Preview" that report.NO
I created a query to filter data. Then Now I am want to add a button to my form to run that query and the result of query view as a report mode. Can I do like that?
Hi. Yes. The easiest way is to create a form for your query and then put it on your form as a subform. On your button, requery or refresh the subform.I created form add add a button to run the query. Is there way to view result on same subform. The Button is on a sub form. when i click the button the result show by opening new tab