I have a query that is using a form named "DateRange2" to change the criteria of one field "Dept1" in order to filter this query. Then the I designed a report that can be opened by using a command button 'cmdOpenReport' with form VBA code:
Option Compare DatabasePrivateSub Form_Open(Cancel...