|
The Movie Search Form and
Subform have a Rating Control, which is Text. This lesson will add
the Genre Control. First, we will confirm that both Forms have the
same Field. Then, we'll use a Query to look up the Rating and
synchronize the Rating and Genre Combo Boxes.
Create a
Genre Table
Add data
to the Genre Table
Edit the Form and Subform
Add the
Genre Control to the Master Form
Use the Property Sheet to
Link the Forms
Confirm the Master and
Child Links
Test the Movie Search Form
Automate the Form with a
bit of code (a Macro!)
Troubleshoot the
Programming
Review the Form and
Control Properties
Review the Master and
Child Links
That's the plan.
Microsoft Access 2010: Example of a Query in
Design View
|
|
| |
