Check value of SetWarnings

[KeithIT]

I'm wondering if there is a way to return the value of the warnings function (terminology??) in access. I know how to set the value, just not how to check it. I am putting together an administrative form that allows the admin or developer to switch back and forth between False and True based on the current value (always resetting to True when the form is unloaded).

I've searched this forum and google but haven't come up with any hits on determining the value. A line of code or a hint on searching would be most appreciated. Thanks!
Keith

 

[Pat Hartman]

This is pretty obscure but I think the property is -
application.GetOption("Confirm Record Changes")

Check out this article in the kb - http://msdn.microsoft.com/library/?url=/library/en-us/dnacc2k/html/acglobaloptions.asp?frame=true

 

[KeithIT]

Pat, it is an absolute pleasure to hear from you.

You're property is correct, but for the benefit of anyone reading this in the future, you can not set the warnings option here using

DoCmd.SetWarnings

. You must set the option using

Application.SetOption "Confirm Record Changes", True (or False)

I went back and changed my code to reflect this condition and it works beautifully. Thanks!