This is looking more and more not possible.
The response argument can have either of two values:
acDataErrContinue: Ignore the error and continue without displaying the Microsoft Access error message. acDataErrDisplay: Display the Microsoft Access error message. This is the default setting.
So my uses of vbOk and vbNo don't do anything.
The acDataErrContinue will suppress the warning popups but the form closes and edits are lost instead of keeping user on the form to complete entries.
Appears my earlier comment about automating response to warning popups was not quite on the mark. With only the two options available, there is no way to tailor the response to the specific warning.