moving to the next record in forms

[Guest]

I have created three forms (I will call the main form "old form" and the
others "new forms). The old form has questions with the "check box" option,
which once these questions are answered with either "yes" or "no" either one
new form opens or the other new form opens or both opens (I created a macro
that does that). However, once these new forms open and their respective
questions are answered they do not go to the following record once I go to
the following record on the old form. How can I make the new forms go to the
next record automatically once I go the next record on the old form?

Miguel

 

[John Vinson]

I have created three forms (I will call the main form "old form" and the
others "new forms). The old form has questions with the "check box" option,
which once these questions are answered with either "yes" or "no" either one
new form opens or the other new form opens or both opens (I created a macro
that does that). However, once these new forms open and their respective
questions are answered they do not go to the following record once I go to
the following record on the old form. How can I make the new forms go to the
next record automatically once I go the next record on the old form?

Miguel

With difficulty!

Why *three forms*? What are their Recordsources? This seems a very
complex way to do things. Can you perhaps use a single Form with tab
pages for the different questions? What is the structure of your
tables?

John W. Vinson[MVP]