I'm trying to make a simple database with only five fields. I want each field to have several predetermined entries. I would like all possible entries to appear in a dropdown box from each field. I can't find any options for adding this. Is it possible in Access. If not is anyone aware of a inexpensive program that it would be?
Hi chaser1326, select your table and go to design mode. select the fields you want, and at the bottom where it show the properties select the Lookup tab. There click on the Display Control text, and the field next to it will display a drop down box. Select List Box At the Row Source Type (that appears after the previous step is completed) select Value List. And at the Row Source put your predetermined entries separated with ; (like option 1;option 2;option 3) take care