Consulting

Results 1 to 2 of 2

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

  1. #1
    VBAX Mentor
    Joined
    Aug 2010
    Posts
    457
    Location

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

    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

  2. #2
    VBAX Regular
    Joined
    Jun 2009
    Location
    Dorset
    Posts
    60
    Location
    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
    Regards
    JD
    ------------------------------------
    Software-Matters
    Dorset

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •