Multiple Message box responses

[Paul Cooke]

Could someone please tell me how I can handle responses to various msgbox's.

At the end of a from the user is presented with a yes / no msgbox. Depending what the response is relates to what happens next.

So in my case

if they answer
Q1 with yes they get Q2

if they answer
Q2 with Yes form does its normal thing

But

If they answer
Q1 with No they get Q3

If the answer
Q2 with no they get Q3

And finally

If they answer Q3 with Yes or No form does its normal thing!

I have tried numerous ways to sort these responses and am even confusing myself ! I have tried using the Elseif but to be honest Im not 100% sure I am using it right as depending where I put it in the order of the code it will work but the Questions then don't come up

Any help or advise on this will be very gratefully received !!

Many thanks

 

[Tidy]

Have you tried a "Select Case" yet.

 

[Paul Cooke]

good point - No!!

I will look into that now - thanks for the reply

 

[gemma-the-husky]

i would use gotos - but it will still be hard to keep track of all the yes no answwers, and the programme flow. 5 questions gives 32 combinations of answers


if msgbox("Q1", vbyesno+vbquestion) = vbyes then
goto Q1yesresponse
else
goto Q1noresponse
end if

Q1yesresponse:


Q1noreposnse:

 

[Paul Cooke]

Ahh thanks Dave

That actually makes sense to me - I appricate there are amny combinations but Im pretty much stuck with the questions so don't have much choice.

luckily it only has to be done form one main form !!

Thanks again