Running Macros - How do I prevent pop-up message?

[Bill Mayes via AccessMonster.com]

I am modifying a form in MS Access 2000 for the data entry folks to allow
them to use checkboxes. I created a Macro to run for each one of the
checkboxes. All of the Macros do the same table join. The only difference
being the numeric value it writes to one table. But each time the data entry
folks check any one of the new checkboxes, a message pops up informing them
of the following:

" You are about to append 1 row(s). Once you click Yes, you can't use the
Undo command to reverse the changes. Are you sure you want to append the
selected rows? "

I need to eliminate this pop up message. Does anyone know how I do this?

Bill

 

[Lynn Trapp]

You need to turn off warnings. If you are working with macros, then you
should add a line prior to the line that appends the records to SetWarnings
False (maybe NO) and then set them back on after that line.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html