Passing data from one form to another

[Guest]

Hi,

I am doing a survey with "skip logic" and therefore have designed 4 seperate
forms:

Form 1 - All participants see this form - one question with Y or N answer
Form 2a - When you answer YES to Form 1
Form 2b - When you answer NO to Form 1
Form 3 - All participants see this form

Currently I've "mickey-moused" something together with macros and am using
the same query on all 4 forms, so when I click "yes" on Form 1, form 2a
appears, however it asks me the ID number (which it already asked for form 1)
again. I get asked the ID number when I proceed to form 3 as well.

Is there anyway of passing the ID number from form 1 to form 2a (or 2b
depending on answer) and then to Form 3 without having to prompt me each time?

BTW, not super proficient in VB - been using wizards and macros mostly.

Thanks in advance.

 

[Guest]

You can pass any data from one form to another in 'openargs'. I don't know
how you do this in a macro but in VBA code its a parameter of docmd.openform
If the earlier forms are still open you can also refer to the values using
the normal form reference [Forms]![Formname]![ControlName]

-Dorian