NotInList event issue

[BobbyDazzler]

Is it possible to utilise the notinlist event to add a new record
WITHOUT using a msgbox for confirmation and WITHOUT opening a form to
add the data. I wan't to be able to enter new data in a combobox and
have it added automatically without the user having to do anything
else. I realise this is prone to errors but it is for a very specific
purpose.

 

[Allen Browne]

There's no need to have the MsgBox if you don't want it.

For an example, see this code:
http://allenbrowne.com/ser-27.html#NotInList
and just omit the 2 lines starting:
If MsgBox(...
End If
(leaving everything between the 2 lines in.)

 

[BobbyDazzler]

Thank you Allen

There's no need to have the MsgBox if you don't want it.

For an example, see this code:
   http://allenbrowne.com/ser-27.html#NotInList
and just omit the 2 lines starting:
    If MsgBox(...
    End If
(leaving everything between the 2 lines in.)

--

Allen Browne - Microsoft MVP.  Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.