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
- [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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
(Locked)
Label control6m 22s
-
(Locked)
Lines and rectangles6m 8s
-
(Locked)
Organize screen space with tabs5m 23s
-
(Locked)
Button controls7m 23s
-
(Locked)
Link to external content5m 38s
-
(Locked)
Select data with a combo box9m 37s
-
(Locked)
Control input with option groups5m 27s
-
(Locked)
Attach external documents6m 23s
-
(Locked)
Add images to a form5m 51s
-
Embed a subform control5m 11s
-
(Locked)
Display a chart6m 39s
-
(Locked)
Link form controls6m 12s
-
Set the default properties for objects2m 9s
-
(Locked)
Edit the Tab Stop sequence4m 35s
-
(Locked)
-
-
-
-
-
-