[AccessD] Sub report filter

Gordon Stubbs gordons2 at pacbell.net
Tue Jan 13 13:14:26 CST 2015


Hello everyone,

It's been quite a while since I have asked a question of the group.
I have a report with a sub-report with a field "Type".
I also have a form with a field "filter-Info".
I would like to filter the sub-report field "Type" based on the field "filter-Info".
How do I get the sub report to do that.
I've tried may ideas and haven't got it to work.

If I modify the query type field criteria to match the "filter-Info" info it will filter correctly.
How can I modify the query criteria using VBA?


Thank you.

Gordon


More information about the AccessD mailing list