Access: Research Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28
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.

 

  Microsoft Access 2007 Exam 77-605 Topic: 5. Presenting and Sharing Data 

  5.2. Filter data  5.2.2. Filter data within queries