Review the Combo Box

There are several places to look when you troubleshoot the Combo Box.

 

What Works, What Doesn't:

Can you see the Rating data?

Can you select a Rating from the list?

Does the Subform display the movies that match the Rating in the Combo Box?

 

2. Try it: Review the Combo Box Properties

Select the Combo Box.

Go to Go to Property Sheet: All.

 

Control Source: Rating

Column Count: 2

Column Widths: 0";1"

 

Where Column 1 (hidden) is RatingID.

and Column 2 is Rating.

 

Do your Control Properties match this one?

 

Keep going...

Form Design Tools->Design->Tools->Property Sheet

 

Exam 77-885: Microsoft Access 2010

3. Building Forms

3.2. Apply Form Design options: View the Property Sheet