|
The Lookup
Wizard walked us through the task of creating a Lookup List. There
are two additional choices in the last step of the Wizard: Limit to
List and Allow Multiple Edits. By default, these options are not
selected. Where
would you change them? Look in the Field Properties: there are two
Tabs! We usually edit the General Properties. There is also a Lookup
Tab. Well, let's look. 6.
Try it: Review the Field Properties Select a
Field: Status. Go to
Field Properties-> Lookup. What Do
You See? The Properties are: Display
Control: Combo Box Row Source
Type: Value List. Row
Source: Limit to
List: Yes (Users can't add to the list). Allow
Multiple Values: Yes (Pick more than 1). Allow
Value List Edits: No.
Field Properties-> Lookup
Exam 77-885: Microsoft Access 2010
2. Building Tables
2.1.1. Create tables in Design View:
Create and modify MultiValue Fields
|
|
| |
