I have a table which of the fields is a lookup field. When I created it in the design view and I chose Lookup ... in the Wizard I chose the option "I will type the values I want".

Now I need to add some more options to the list ... where shall I go so that I can type the other values which i would like to add ?

Thanks

In the RowSource of your field you can add more options to your Value List.

that's what i did, but when i added them manually, then in the form in the drop down list, the new entries didn't appeared there. For example in the row source i had the following:

"a"; "b"; "c";

Now i added the following manually next to them:

"a"; "b"; "c"; "d"; "e";

However, when entering data in the form in the drop down list only the a, b and c are visible to select from.

Thanks

When you created the form, Access obtained the information for the combo from the table and stored it in the form. There is nothing in the form that will cause it to go back to the table and pick up new data. That is why this method is not recommended. A lookup table is safer because the values will always be as current as what is in the table. You can also establish a relationship and enforce referentiental integrity to prevent erroneous entries.

To update the form combo, either add the new entries manually or delete the control and re-add it.

But, the best solution is to create a lookup table and use that as the rowsource for the combo.

thanks for the info.