Help please

E

Edwin Merced

I have a table with 3 questions. Each is a field name question 1, 2, & 3. It
is a Yes /No field type.
I have another table with the following memo type in a field named
explantions:( No explanation for question 11, No explanation for question 2,
No explanation for question 3) What must I do to have a form where If I clic
No to question one , onl;y explanation one pops up as an option and if I
clci No to question 2, only explanation 2 pops up as an option etc.
Do I need a subform. I have no ideo on how to go abaout on this project
Tnaks
 
D

DevalilaJohn

You're headed in the right direction. I take it that your table of questions
is where you capture the answers. If that is the case, make sure you have a
common key between the tables (e.g. question number).

Go ahead and build your form for the questions and add the subform for the
memo field. The easiest way to add the subform is just drag it from the
forms page onto the form you are building. You will be prompted to identify
the common connection. Once that's in place the two will synch up
automatically.

If you establish the relationship between the two tables before dropping the
subform in, Access will "guess" that to be the relationship you want to use.
 
E

Edwin Merced

Thanks for the motivation. Now this question: If I only want to capture the
no responses on a Report. What must I do in the Form? Must I make a query?
 
Top