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