I have a regular button on the form with (Save as and Subform.access = "Protected") code written and on click of it, I am showing a messege box as "Do you what to save" with "Yes" and "No" options. When I click YES it opens a Save window and ask for the location to save. This save window has two button Save and Cancel. Upon hit of a cancel it executes a the "subform.access" code in click event.
Can anyone help here?