Fill information in form based on other form

[Alex]

Hi,

I posted this question last week and Barry was helping me with it. I am not
able to get it to work...he suggested filling the default value of the field
on the QA form with =Forms![test_attempt].<valuename>. Since this post is
now way back in the list, I hope it was okay to repost...if this is not the
thing to do, i am sorry.

Is there anyone, or Barry, who can give me some more help on this??? I am
getting desperate!

I have a form (Registrants) with a subform (Test attempt). On the subform,
there are fields: Test_ID, Registration ID. There is also a command button
which opens another form called QA.

The form QA has fields: question, answer, registration id, test id. It is
based on a query.

I need the form QA to pull the registration id and test id from the subform
Test Attempt. However, I don't want the form to requery based upon the test
id and registration id since then it would be empty. I want it to fill these
fields in instead. Make sense?

Is there a way to do this?

Thanks,

 

[Jeff]

Hi,

I posted this question last week and Barry was helping me with it. I am not
able to get it to work...he suggested filling the default value of the field
on the QA form with =Forms![test_attempt].<valuename>. Since this post is
now way back in the list, I hope it was okay to repost...if this is not the
thing to do, i am sorry.

Is there anyone, or Barry, who can give me some more help on this??? I am
getting desperate!

I have a form (Registrants) with a subform (Test attempt). On the subform,
there are fields: Test_ID, Registration ID. There is also a command button
which opens another form called QA.

The form QA has fields: question, answer, registration id, test id. It is
based on a query.

I need the form QA to pull the registration id and test id from the subform
Test Attempt. However, I don't want the form to requery based upon the test
id and registration id since then it would be empty. I want it to fill these
fields in instead. Make sense?

Is there a way to do this?

Thanks,

Hi Alex!

If QA is only opened by the command button on the subform then:

on the QA form QA_registrationID control get the default value property

Forms!Registrants!SubformControlName!registrationID

on the QA form QA_testID control get the default value property

Forms!Registrants!SubformControlName!testID


** subform control is usually NOT the name of the subform.

Look on the mainform and click the subformcontrol that hosts the
subform, a black square appears around the subform but the square in the
top left of the subform is not black!
Look in the properties and find the name.

hope this helps!

Jeff

 

[Barry Gilbert]

Alex,
I posted a reply in you original thread.