|
There are
two Columns in this Combo Box: Column 1:
MovieID Column
2:Movie Only one
column will be seen in the Drop Down List. If the Key Column is not
hidden then Users will see the MovieID, Column 1, and
not the name of the Movie, Column 2. By
default, the Combo Wizard hides the Key Column, so
Users will see the Movie name.
3.
Try it: Hide the Key Column Hide the
key column. Click
Next. Keep
going... You May
Have Noticed: This walk through the Combo Box Wizard accepted
the default to Hide the Key Column. Why is this so? This Form saves
the Primary Key, not the Text, to the Table so it goes with the
Default. In a Normalized database there are only Key numbers, not
Text, when you get to the final summary (tblMovieRented).
Form Design Tools->Design->Controls->Combo
Box
Exam 77-885: Microsoft Access 2010
3. Building Forms
3.2. Apply Form Design options: Add
Drop Down Controls |
|
| |
