"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)