Data for the Combo Box

Where does a Combo Box get the names on the list? A table is a good place to look up the data. You need to design a table for the ratings.

 

Try it: Create a Record Source

Go to the Table tab

You should see the Table Design Tools Click on Create ->Table Design

 

Add the Fields

In the first field, type: Rating

Data Type: Text

Field Size: 4

 

Save the table and name it: tblRating

If Access prompts for a Primary Key, click No.

 

Memo to Self: The field size was set at 4 to keep the data consistent. If a user types in PG115, the database will beep and say that the entry is not valid.