How can I easily copy the filter on a form to a report??? TIA Henro
V Van T. Dinh Dec 19, 2005 #2 You can access the Form's Filter String using: Forms!YourForn.Filter and you can use this in the "WhereCondition" argument of your OpenReport method (provided that all Fields referred in the Form's Filter are also in the Report's RecordSource).
You can access the Form's Filter String using: Forms!YourForn.Filter and you can use this in the "WhereCondition" argument of your OpenReport method (provided that all Fields referred in the Form's Filter are also in the Report's RecordSource).
