Combo Wizard: Which Step?

The next to last step in the Combo Box Wizard asks you to select which value to Store in your Table.

 

What Do You See? The list shows the Fields in tblMovies, the Record Source for the Movie Form. There is a Rating Field, which is TEXT.

 

The Combo Box Wizard automatically picked the Primary Key from the Rating Table. The Primary Key, RatingID, is a NUMBER.

 

RatingID doesn't match Rating. Text goes with Text. Numbers go with Numbers.

 

The Wizard chose the Primary Key and the key Column was hidden. However, when you get to this step you cannot select the Field that matches.

 

How Did This Happen? This step is actually Step 7. The Combo Box Wizard assumed that the Control would save the key data, so it skipped Step 6, the one that asks you to choose a Field.

 

6. Try it: Go Back a Step

Click Back. See what was missed...