<div>
You must set the LimitTolist Property to False in order to avoid this message.<br />
<br />
Bye.<br />

</div>


You must set the LimitTolist Property to False in order to avoid this message.

Bye.


<div>
marcoszorrilla,<br />
<br />
Setting &quot;Limit to list&quot; to &quot;No&quot; will suppress the &quot;OnNotinlist&quot; event....<br />
<br />
Nic;o)
</div>


marcoszorrilla,

Setting "Limit to list" to "No" will suppress the "OnNotinlist" event....

Nic;o)

<div>
How do you add the new entries?<br />
<br />
Once you have added them to the source table of the combobox, you just refresh your combo:<br />
<br />
...<br />
your code<br />
...<br />
Me.ComboBox.Requery
</div>


How do you add the new entries?

Once you have added them to the source table of the combobox, you just refresh your combo:

...
your code
...
Me.ComboBox.Requery

<div>
Setting &quot;Limit to list&quot; to &quot;No&quot; will suppress the &quot;OnNotinlist&quot; event....<br />
<br />
I have just made the test and it is exactly this way. &nbsp;<br />
Nic;o) &nbsp;you are right.<br />
<br />
Bye.<br />

</div>


Setting "Limit to list" to "No" will suppress the "OnNotinlist" event....

I have just made the test and it is exactly this way.  
Nic;o)  you are right.

Bye.


<div>
That's it, Nico!!<br />
Every day I'm learning something new...<br />
<br />
Thank you for your cooperation, have a nice weekend!<br />
<br />
Roger.
</div>


That's it, Nico!!
Every day I'm learning something new...

Thank you for your cooperation, have a nice weekend!

Roger.

<div>
Nice weekend too ;-)<br />
And success with the application !<br />
<br />
Nic;o)
</div>


Nice weekend too ;-)
And success with the application !

Nic;o)

<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
I use the 'on not in list' combobox property to run some VBA code for opening a form where I can add new entries (codes and descriptions).<br />
After showing a msgbox ('do you want to create a new entry?'), there is always a standard Access information message showing up 'The text you entered is not an item on the list'.<br />
How can I avoid this message?<br />
I already tried setwarnings false and on error goto 0.<br />
<br />
Does anyone know?<br />

</div>
</div>


Hello,

I use the 'on not in list' combobox property to run some VBA code for opening a form where I can add new entries (codes and descriptions).
After showing a msgbox ('do you want to create a new entry?'), there is always a standard Access information message showing up 'The text you entered is not an item on the list'.
How can I avoid this message?
I already tried setwarnings false and on error goto 0.

Does anyone know?


on not in list property

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.