Introducing
Your new presentation assistant.
Refine, enhance, and tailor your content, source relevant images, and edit visuals quicker than ever before.
Trending searches
Applying Data Validation Rules 2
161
Creating Table Lookups
Select the Lookup tab and change the Display Control property to ComboBox.
Set the Row Source Type to be set to “Table/Query”.
Set the Row Source property to tbl_items.
Creating Table Lookups
Creating a table lookup is very similar to creating a value lookup.
We often use these on foreign key fields, to ensure users can only choose a value from the matching primary key field.
This time, open the tbl_part_order table and select the Item field.
KnowItAllNinja.com
Applying Data Validation Rules 2
Creating Value Lookups
In the Row Source Type property, set the drop down to Value List.
In the Row Source property, list out the values we want in the combo box, with each value separated by a semi-colon (;)
Creating Value Lookups
http://www.knowitallninja.com
Creating Value Lookups
Select the County field and in the field properties panel select the Lookup tab.
Set the Display Control property to ComboBox.
To prevent users inputting values not in our list we need to set the Limit To List property to Yes.
Other useful properties include:
- List Rows – Try setting this to 5.
- List Width – Try setting this to 3cm.