own wornings message

[thierno]

I use a list box with textfield to fill a form in but when I fill in data which is not in the listbox, I get a warning from MS Access: "The data you privide is not an item from the listbox , Please choose an item from the list." No probleme at this point!

But me I want set off this wornings and to use my own worning message. I have tried D0cmd.setwornings False.

I get my own worning message but after I still get the message from MS Access.

Any Idea how to solve this probleme. I will be gratiful.

Thanks in advance for your answers.

 

[Crilen007]

warning. not worning.

 

[hooks]

Right click on combo box in design view. Click properties. Click event tab. click on the ... in the On Not In List Event.

MsgBox "Your selection is not in the list.", ,"Not In List"

 

[thierno]

Thanks all of you for your answers,

I've alreay tried it but I get my own warning message but after I get also the warning of MS Access.

I want to off the warning of MS Access.

thanks in advance for any help.