form to filter for the criteria, then open the report based on that criteria.
Posted on 2011-09-11
I have a form and report in Access 2010. I want to filter the report from a combo box on the form with the submit button is pressed ("onClick"). Im able to open the report with the button but im having a lil difficulty filtering the report based on the drop down selection of the form. I've researched and see i have to place the filter on the data the report is pulling from but not sure how to exactly do that, any ideas???