Here is my macro which occurs under the close form property of my form.
condition: if [forms]![customer]![name] is not null
Action: StopAllMacros
condition: 6<>msgbox("This record will not save. Close form anyway?",36)
Action:CancelEvent
What I wanted it to do was close the form when the user choose YES, but form closes even if no is pressed.
Please help.
condition: if [forms]![customer]![name] is not null
Action: StopAllMacros
condition: 6<>msgbox("This record will not save. Close form anyway?",36)
Action:CancelEvent
What I wanted it to do was close the form when the user choose YES, but form closes even if no is pressed.
Please help.