Receipt Form Design:

Combo Box Key Decision

There are two Columns in this Combo Box: CustomerID, which will be stored in the Receipt Table, tblReceipt, and HomePhone, which is what the User should see when they select the Combo Box. If you want the User to see the second Column, you have to hide (resize to zero) the first Column.

 

6. Try it: Hide the First Column

Select the first Column: CustomerID.

Resize the first Column: 0"

 

Go Next. Keep going...

Form Design Tools->Design->Controls->Combo Box

Exam 77-885: Microsoft Access 2010

3. Building Forms

3.2. Apply Form Design options: Add a Drop Down Box