Access: Research Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17

Office->Save As

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.