The final step in linking the report to the main menu combo boxes is to hook them into the underlying query. In this video, Adam uses the Expression Builder interface to link the criteria for region and month to the selections made on the main menu form. This completes the cycle and the finished, customizable report is generated.
- [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 Menu open,…so I can choose the Loaded Forms folder and find it there.…
Author
Adam Wilbert
Released
12/10/2018- Creating forms with the Form Wizard
- Formatting and aligning form objects
- Combining text boxes
- Adding a form header
- Organizing screen space with tabs
- Controlling input
- Adding images
- Linking form controls
- Creating menus and data entry forms for the database
- Building reports
- Creating calculation fields
- Linking forms and reports
Skill Level Intermediate
Duration
Views
-
Introduction
-
Trust the exercise files1m 25s
-
1. Making the Most of Forms in Access
-
Create a form with subforms5m 11s
-
2. Form Design Basics: Creating an Employee Directory
-
Object alignment5m 58s
-
Anchor controls3m 54s
-
Modify form properties5m 8s
-
Additional form properties1m 44s
-
Combine textboxes2m 54s
-
Add a form header4m 51s
-
3. Form and Report Controls
-
Label control6m 21s
-
Lines and rectangles5m 55s
-
Button controls4m 18s
-
Button properties3m 37s
-
Link to external content4m 22s
-
Add data with a text box3m 21s
-
Select data with a combo box6m 32s
-
Additional image properties4m 20s
-
Embed a subform control5m 27s
-
Prepare a query for charting1m 26s
-
Display a chart5m 32s
-
Link form controls5m 24s
-
Edit the Tab Stop sequence4m 48s
-
-
4. Getting Around the Database
-
Create a main menu5m 53s
-
Refine button macros4m 54s
-
Create a data entry form6m 47s
-
-
5. Report Layout
-
Understand report structure8m 13s
-
Build a report from a query4m 54s
-
Create calculation fields5m 49s
-
Add a report header5m 5s
-
Segment dates into groups4m 31s
-
Format date header sections3m 42s
-
6. Linking Forms and Reports: Creating a Profit Summary
-
Build the query5m 2s
-
Create the report structure4m 51s
-
Connect the form5m 42s
-
Connect the query4m 34s
-
-
Conclusion
-
Next steps1m 2s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Connect the query