Access: Form Design 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

Form Design Tools ->Design -> Combo Control

 

Combo Box Wizard

Store the Data

The next question in the Combo Box Wizard is very important. Do you want to store the data? Yes.

Our Movie form is based on the MovieTitle table. The movie table has a field for Rating.

 

When you select something from the Rating Combo, you are using the Combo Box to copy data from the Rating table and put it in the MovieTitle table.

 

Memo to self: A database is all about matching. You used the Combo box to get the Rating data. The Rating data should be stored in the Rating field. It matches.