get rid of message box?

[xq]

i've created a form which allow user input data, those data will be saved in to several tables by clicking 'add record' buttom, but once the button is clicked, a message box from access always appears, says "You are about to append 1 row(s) once you cliked yes you can not ...", and let me to choose 'yes' or 'no', and i dont' want user to see that, is there any way to get rid of that?
thanks lot!

 

[KingAndy]

xq

If your running code behind the button add the following lines before and after your existing code.

DoCmd.SetWarnings False

***** YOur Code here *******

DoCmd.SetWarnings True

If you are using a Macro use the SetWarnings Command.

Andy

 

[xq]

great! thanks!