"Is there a way to interrogate the status of SetWarnings. Stating it another way, is there a function
which when run would return whether SetWarnings is on or off?"
According to Access help, there's actually 3 parts of this option:
"Confirm Record Changes"
"Confirm Document Deletions"
"Confirm Action Queries"
Use something like this to test:
Debug.Print GetOption("Confirm Action Queries")
returns -1 (True) or 0 (False)