The Simplest of Lookup Lists - the Y/N Drop Down List
First you may say why use a Y/N field - use a check box.
The answer is: don't use check boxes on forms! They are difficult to sort by and simply clicking in or near the field will cause the value to change - often accidentally.
Use a text field in your table with a length of 1. Put a Validation Rule such as: 'in ("Y","N")'. Don't define a lookup in the table design (while not as important on a Y/N field, you'll see why this is discourage in discussions in our other examples).
In form design view click the icon for a Combo Box and drop it in your form. The combo box wizard will activate. Choose to enter your own values. Then put a Y in the first line and a N in the second line. In may choose a default answer in the next screen. Finally, tell the wizard with which table field the
combo box will be associated.
Find additional Combo Box examples both simple and complex in
our download section:
Make Dependent Combo Box Code Access
Database Download ... Once you have mastered the simple case
of a dependent combo box on a single-record form it is ...
www.blueclaw-db.com/download/continuous_dependent_combo_box.htm |
Student FROM M_Students WHERE (((M_Students.Advisor_ID)=[Forms]![F_Combo]![Advisor_Combo]));.
Download our Access Dependent Combo Box programming example.
...
www.blueclaw-db.com/download/dependent_combo_box.htm |
New! Download Access example of
Dependent Combo Box ... Here we filter a lookup list/combo
box based upon another dropdown list on the form. ...
www.blueclaw-db.com/comboboxlist/access_dependent_dropdown_list.htm |
