Set warnings not working correctly

[Robert Taylor]

I have a form that uses update queries to update some
tables, and to cut down on the confusion of the system I
used the DOCMD.SetWarnings False to turn off the message
boxes about running update queries.

For some reason, while this runs as the first thing when
the form opens, the message boxes are still coming up
until I close and reopen the form.

Does anyone know of what could cause docmd.setwarnings not
to work immediately after you reset its values? Or how I
can get it to work correctly?

Thanks.

Robert

 

[Crystal]

Where is your setwarnings code?

This sounds like it might be a logic error. Use the
breakpoints to step throught the code after you set the
value and see what you code's doing. Maybe the line just
needs to be moved?

Hope this helps,
Crystal