Is it possible to create on a yes/no message box when the user select no it will halt the program from progressing to the next step on a form in access 2007?
Thanks
Is it possible to create on a yes/no message box when the user select no it will halt the program from progressing to the next step on a form in access 2007?
Thanks
If you put the yes/no msgbox on the beforeupdate and teh if the user chooses no can stop it from progressing to the afterupdate. Something like this:
If msgbox("My message"),VbYesNo) = VbNo then
cancel = true
me.undo
else
....
code as required
....
end if