From the course: Access 2019: Forms and Reports

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Connect the query

Connect the query

From the course: Access 2019: Forms and Reports

Start my 1-month free trial

Connect the query

“

- [Instructor] We're getting close to final functionality that we need for our Profit Summary report. The final step is to connect the combo boxes that we have on our Main Menu here to the query that's driving the report. This will allow our end user to choose the month that they want to see, as well as the region that they want to see, on their customized Profit Summary. Let's go ahead and open up the Profit Summary query by right-clicking on it and opening it straight into Design view. Then, in order to filter those results, all we need to do is provide a criteria that links back to the form. We'll do that underneath the MonthName column, as well as the Region column. Let's do the MonthName first. I'll right-click in the Criteria box and choose Build. That'll open up the Expression Builder. Now, we just need to make a reference to the combo boxes on our Main Menu form. We can do that by drilling into the Database folder, then opening up the Forms folder. I currently have the Main…

Contents