code to display next page of multipage form based on answer to questions on existing page

[Ishwarind]

Hi All,

I have series of question as below with Yes/No option button to answer.
Q1. Yes No
Q2. Yes No
Q3. Yes No
Q4. Yes No
Q5. Yes No
I want user to answer all the question. Sequence of answering is not important. If answer to all the question is "Yes" user should be able to view next page of form by clicking the comand button. If answer to any one or more question is "No" should not have access to next page and Msg Box to be displayed "Please close the form".

[lancer102rus]

are you kidding? It was already done for you: #post3796212

[Ishwarind]

Hi Lancer,
Its different.
We progressively went through questionaaire. What I intent is to display all questions at the same time. Sequence of answering is not imp.

[lancer102rus]

Well then attach example file with questions and option buttons

[Ishwarind]

Hi Lance,
Sorry for delayed reply.
I have done it with IF & And statement in VBA code.
viz: If ob1.value=true and ob1.value=true then
step II
Else
Msg box as required.

Thanks for your support.