Rocky Smolin
rockysmolin at bchacc.com
Tue Jan 13 15:09:13 CST 2015
Make a query to do what you want. Then go to the SQL view of the query and copy the sql out. In the sub-report's Open or Load event set the record source to that sql string. I do this a lot when there's a form with a bunch of filtering criteria to filter the contents of the report. Rocky Smolin Beach Access Software 858-259-4334 www.bchacc.com www.e-z-mrp.com Skype: rocky.smolin -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gordon Stubbs Sent: Tuesday, January 13, 2015 11:14 AM To: ' Access Developers discussion and problem solving' Subject: [AccessD] Sub report filter 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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com