Don't prompt for add/delete row in a table

[PikPim]

Hi, I'm building a form in which there are checkboxes. Everytime you check or uncheck a checkbox, it creates a new row in table with an SQL statement. It works fine, the only problem is that everytime you click you get a message saying something like: You are about to create a new row in a table, are you sure you want to do that? Or, You are about to delete a row (bla bla bla). I would like to know how can i turn this anoying message box off! plz!! there must be a way!!
?hanks in advance

 

[PHV]

Have a look at the DoCmd.SetWarnings method.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886