How to Filter Multiple Reports - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

How to Filter Multiple Reports

Alexis Cao

4 years ago

Hello,
Hope everyone goes well. in the recently, i met a problem of how to filter multiple invoice with one customer by using the VBA code.
i know how to select the specific invoice with Form with VBA code ( where condition), also know to make a query with cricia with Forms!....; but i don't know to how to select a series invoice report with one customer, is it possible?

	Alex Hedley @Reply 4 years ago
What Field are you filtering on?

	Alexis Cao OP @Reply 4 years ago
filter customer, you know, one customer maybe have more than one invoices or orders, i want to filter one customers with a botton, can show all invoice report with this customer.

	Alex Hedley @Reply 4 years ago
So do you have a `CustomerID` in your `InvoiceT`?

	Alexis Cao OP @Reply 4 years ago
Yeah, I used the docmd.open query and at the condition point used the customerId, it doesn''t work

	Alex Hedley @Reply 4 years ago
Can you write a query instead, hard code a `CustomerID` you know had multiple records.

	Alexis Cao OP @Reply 4 years ago
`DoCmd.OpenReport OrderR, acViewPreview, , "CustomerID=" & CustomerID`

	Alexis Cao OP @Reply 4 years ago

	Alexis Cao OP @Reply 4 years ago

	Alexis Cao OP @Reply 4 years ago
it appears problem as the screenshot, i also think my code is not right, becasue there are three invoices at the "alexis cao" customers

	Alexis Cao OP @Reply 4 years ago

	Alexis Cao OP @Reply 4 years ago
i know it can be worked by `Forms!CustomerF!CustomerID` in the query, and then `DoCmd.OpenReport OrderR, acViewPreview`. but how it should write, only by VBA code, my friend

	Alexis Cao OP @Reply 4 years ago
Is it possible only by VBA code?

	Kevin Robertson @Reply 4 years ago
The name of your report should be in quotes. `DoCmd.OpenReport "OrderR", acViewPreview, , "CustomerID=" & CustomerID`

	Alexis Cao OP @Reply 4 years ago
it worked, thanks Kevin 0.0

	Alexis Cao OP @Reply 4 years ago
By the way, according to this question, Mr.Richard has a open a specific report used a ''me.filter'', does the website has a more explaining video about that? I have the ''me.filter'' is more powerful, but the lessons two less about it.

	Alex Hedley @Reply 4 years ago
Run-time error '2497': The action or method requires a Report Name argument. What did you think this error meant Alexis?

	Alexis Cao OP @Reply 4 years ago
I ignored it, my mistake. Alex

	Alexis Cao OP @Reply 4 years ago
My attention didn''t put the run time error

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View