Hi everyone,
I have the following simple question. How can I restrict the field entries in a table to a few selected values? For example, I have the field name 'Month' and would like to restrict the entries to: January, February, March, etc... In the table I would then like to have a drop-down menu from which the user can select a month for every new entry. Can anyone help please?

Data should not be entered directly into a table by opening the table itself. You really should use a form. Then in your form you would create a combo box with the value list in it which is bound to the field in the table.

Okay, I've created a form from the existing table. I changed the text entry for month to a combo box, set row source type to value and typed in the different values allowed (e.g. January, February, March, etc.). In the Form View I can now select from 12 different values. However, once I select a given month for the first entry, all other entries change to the same month. If I change the month field in the second entry, all entries change to that month respectively, including the first one. What am I doing wrong?

Nevermind. I forgot to bind the combo box to the table entry. It works fine now. I intend to use froms from now on (Access newbie). Thanks for your help