linking forms

I hope that someone will be able to help. I am constructing a form to be used for questionnaires of approx. 2000 subjects. I have numerous topics (>10) which I put into different forms. I am now having problems linking these forms. When a form (topic) is finished I would like to go automatically to the next form. Also before doing this I would like the record saved. If you have any suggestions it would be most useful.

Also I have programmed the form so that if a question is answered as no a number of questions are skipped, this is no problem until I get to a question that leads to the end of the form or to the next form, please help!

Lesley

Ok..with that many forms, you are in for a real treat. Anyway you could break them down further and use subforms?

In anycase, you need to have button that uses its OnClick event to:

1) Open the next form
2) Pass the PrimaryKey form the currentform to the new
3) Close the form you were on and save the record.

I will wait until I hear if you can break it down more.

Anyone else is welcome to help out as I will be really tied up tomorrow and probably can't get back here 'til late evening.

Jwindon, thanks for getting back to me so quickly.

I have now been able to create command buttons to save and open the next form, however could you possibly help me in transferring the primary key from one form to the next as I am not sure how to do this.

THANKS