Request : How do I add new data in form view with Combo box ?

[Mike_UK]

Hi,

The advice I would like is for the following.



I have a drop down in my form which looks at the entries in my recording artist table.
If I have already created that artist within my table - the drop down in the form will recognize it.
If I try to enter a new artist the error message "The text you entered isn't an item in the list. Select an item from the list, or enter text that matches one of these items" appears.

So, I would like to add the new artist name in the form and for that artist to be automatically added to my table.

Currently, I would have to go back to my table. Add the new artist record. Save the table. Close my open form. Reopen the form. The new artist name will then appear in the combo drop down.

Thank you.

[RuralGuy]

That can all be accomplished in the NotInList event which will fire if you set LimitToList true.

[Mike_UK]

Thank you RuralGuy.