update query - suppressing update popup box

[ytakbob]

Does anyone know how to suppress the question of "...do you
want to continue before updating these rows...?"

We are running Access 97 within VB script, building the
sql and executing a docmd.runsql


Bob Schmid
bob_schmid@hmis.org
330-746-1010 ext. 1347

 

[cghoga]

Hi Bob.

Try this....

DoCmd.SetWarnings False 'to turn off.

and

DoCmd.SetWarnings True 'to turn back on.

Hope this helps.