Synchronized Combos
A query is one method
of linking two combo boxes.
Here are the steps to build a query for the RatingCombo.
1.
Open RatingSearchSQ in
Design View.
2. Confirm
that your QBE grid has the Rating
field from tblRating.
Add: [tblMovieTItles]!ID
to the grid.
3. Go to Office->
Save As and name the query: RatingSearchSQ.