How can I change the page/tab order dynamicly?

[Marshallp24]

Hi,

I have created a form with loads of tabs, each one has a question,
answer and question number. The question number is different based on
how the questions were answered, so they can be out of order
sometimes. The form is for reviewing answers, not answering them.

I would like to be about to link the page order to the question number
on the page. So question 1 is page 1, if question 7 was answered next
(because the user was asked to skip 2 to 5, based on their answer to
question 1 for example) then question 7 is question 2 and it should be
page 2.

I cant just make 2 to 5 not visable because based on the users other
answers they might be forced to come back to question 3 for example.
This is unavoidable So I want to change the page order so it is equal
to my answer number.

Also, curently I have buttons on each page that take you to the next
page, basicly its: on click Q2.setfocus. But I'd need to go to the
next page whatever that might be.

I really want my form to be dynamic, but I'm not sure how this problem
could be solved. Can anyone help???

Cheers.

Paul

 

[Marshallp24]

Sorta worked it out:

Me.Q16.PageIndex = Val(Me.Q16No)


Not sure how the next and previous buttons will work......