From the course: Access 2016: 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.

Link form controls

Link form controls

From the course: Access 2016: Forms and Reports

Start my 1-month free trial

Link form controls

“

- [Voiceover] Now that we've seen all of the controls that we have at our disposal when creating forms and reports, let's bring this full circle and piece together a couple of objects that'll control the chart that we created in the last movie. If you remember, we finished that movie with this Order Dates form here. On the Order Dates form, we have a graph, and that graph is pulling data out of Order Dates query. And basically, what we're seeing here are bars that represent the number of orders that occurred in each month. Now, what I'd like to do, is create couple of Combo Boxes on this form that'll allow me to select some dates. Then, we'll use those dates to dynamically filter the results of this chart. Let's go ahead and get started on this project by going into Design View. I'm gonna come here to the ribbon, and we'll grab a new Combo Box here, and click to add that in here. That'll start up the Combo Box Wizard, and I'm gonna tell you up front, this is not gonna be the solution…

Contents