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 a query to a combo box

Connect a query to a combo box

From the course: Access 2019: Forms and Reports

Start my 1-month free trial

Connect a query to a combo box

“

- [Instructor] At this point our form includes a chart built from data coming from a query and two combo boxes that'll allow the end user to choose dates at that start and the end of a range that they're interested in seeing presented in the chart. Now we need to go back to the query and connect it to these combo boxes. So let's go ahead and do that. I'm going to right click on the query. We're going to open it into design view. Then I want to filter my results based off these selections that I make in the combo box. In the Order Date column I'll come to the criteria row and right click and go into the builder. For the expression I'll type in the keyword between. I'll type in a space and then we'll come into the folder representing our database. I'll open up the forms. I'll open Loaded Forms since our form is currently open right now and chose the Order Volume form. And I'll double click on Start Date. Then I'll type in the word and and double click on End Date. That'll specify a…

Contents