I was trying to use “exit sub” on AXFormClose to prevent closing the form but I cannot get it to work correctly.
if flag<>“Y” then
msgbox (“Please select Campaign Response “), 64,” SelectCampaignResponse”
if (Sender.ModalResult =2 and flag<>“Y”) then
AXFormCloseQuery = false
AXFormCloseQuery = true