Hello and thanks in advance!

I am adding and deleting rows from a table using VBA code in a form.

When running the form, I wanted to know how to stop that message from popping up that says 'you are about to append 1 row into the table' and you have to click ok for it to continue. Also, I wanted to stop the message from popping up that says the same thing about deleting rows when I choose to do that.

Thanks!

How are you deleting the rows? There may be a way to do it without resorting to this, but here you go:

You can use

DoCmd.SetWarnings False

and then put your code and then use
DoCmd.SetWarnings True
to turn them back on.

The caveat is this - if you use this be sure to put in an error handler and include the DoCmd.SetWarnings True in the error handler so you don't find yourself without error messages at all if something fails before it can get back to being reset.