By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,654 Members | 1,513 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,654 IT Pros & Developers. It's quick & easy.

How to specify infomation in a report using VBA...

P: 37
I want to have a specific set of registers to be showed in a report, but if I change the filter before the report is oppened, a error will ocurr and if I change the filter afterwards, the file has already been printed.
What is the way to solve that?

Best Regards
Ricardo de Milano
Jun 27 '14 #1

✓ answered by NeoPa

The DoCmd.OpenReport() function (which you use to open reports) has a parameter (WhereCondition) that allows you to specify filtering information for the particular instance of that report. That means it won't change the design of the report itself, just apply that filtering as and when it runs this particular line of code.

Share this Question
Share on Google+
3 Replies


NeoPa
Expert Mod 15k+
P: 31,769
The DoCmd.OpenReport() function (which you use to open reports) has a parameter (WhereCondition) that allows you to specify filtering information for the particular instance of that report. That means it won't change the design of the report itself, just apply that filtering as and when it runs this particular line of code.
Jun 27 '14 #2

P: 37
Dear Mr. NeoPa...
Thank you very very much for your answer. I haven't tested it yet, but the answer is so clear that I don't believe I will have problems.
Thank you very much.
Ricardo de Milano
Jun 30 '14 #3

NeoPa
Expert Mod 15k+
P: 31,769
You're very welcome Ricardo :-)
Jun 30 '14 #4

Post your reply

Sign in to post your reply or Sign up for a free account.