Log in

View Full Version : Is it possible to create a halt feature on a yes/no combo dropdown list menu



wedd
09-21-2010, 07:59 AM
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:clap:

SoftwareMatt
09-21-2010, 09:15 AM
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