Adding new data to a form based on a lookup table

[Tlyles]

I have a form that enters data into a lookup table, but I am only able to use items already in the tables used to make the lookup table.



I get this error message: The text you entered isn't an item in the list.

I know there is a way to modify a form like this so that I can enter new data into the tables via the form, but I can't figure it out.

Anyone know what I should be doing? Also, pls let me know if there is a clearer way to explain my problem.

Thanks.

Toby

[orange]

Please give us more info, even an example with sample data, about your lookup table.

[Tlyles]

I have a lookup table that comes from three other tables: name-table, month-table, action-table.

The month-table and action-table never change. They include every month of the year and actions like update, compile, email.

I do add new names to the name-table, but I want to do this via my form.

The lookup table tells me which action was taken for each name during any given month.

The lookup table looks like this:

Name Action Month
Iowa Update November
Idaho Update October
Illinois Update August
Iowa Compile November
Idaho Email September
Illinois Compile November
Iowa Update October
Idaho Update November
Illinois Update November

The FORM I use to enter the data looks like this:

Name [entry box]
Month [entry box]
Action [entry box]

Every time I try to enter a name that is not already in the name-table, I get this error message: The text you entered isn't an item in the list.

I know there is a way to modify a form like this so that I can enter new data into the tables via the form, but I can't figure it out.

Anyone know what I should be doing? Also, pls let me know if there is a clearer way to explain my problem.
Toby

[June7]

One way is with code in the combobox NotInList event. This is a common topic. Start with https://www.accessforums.net/access/...ate-55139.html