"NOT IN LIST" event not working on combo box

[Oyster]

I have a data entry form which allows users to add data to table A. On the form is a combo box populated from table B, that creates a list of values the user can pick from during data entry. If the user doesn't find the desired value in the combo box, then the value needs to be added to table B before it can be added to table A. On the combo box, box I have the event "NOT IN LIST" set to launch a macro to open a form that will allow an item to be added to table B. But its not working. In fact, nothing happens at all.

To get around this, I added a button to my form that allows the users to open a form which will allow the new value to be added to table B. But this isn't working correctly either since the combo box on the data entry form for table A doesn't show the new value.

Help would be appreciated.

 

[Oyster]

Found the answer!!!

Didn't have all the properties set properly:

The combobox must have it's RowSource set to either a table or a query (not value list or file)

The combobox must have the RowSource Type set to Table/Query.

You must set the Limit To List property to Yes (this is the one I forgot to check).

(Source: http://www.microsoft-accessolutions.co.uk/not_in_list.html)