Tables and Forms, Survey Form

[julia]

I need to design an input a userface in a form in which
the input is related to a 2nd table. It seems that Access
will only let me create option groups for data to go into
one field of one table.

Table1 has field [HasConcern] relating to the question:
Do you have a concern?

Table2 has fields [Concern1], [Concern2], [Concern3],
[Concern4]

1. These detailed concern fields: can they be linked to
table1 [HasConcern]? Do they need to be?

2. Also, I would like each option to have a control source
from this second table, corresponding to fields in the
second table, such that o[concern1]
o[concern2]
o[concern3]

Each radio button would give a y/n answer in each field to
indicate which concerns were expressed. How do I do this?

 

[Chris]

What I'm getting from you is this: You want the list of
concerns to pop up in the second form if [HasConcern] is
activated in form one, each option corresponding to a
yes/no field in table2.

In that case I'd suggest not using an option group, but a
series of independent check boxes, each with a
corresponding yes/no field in table2.

You can then make these check boxes visible when you click
the option in form1. For example with an onClick event for
the checkbox:

Forms![Form2]![Concern1].Visible = [HasConcern].Value
Forms![Form2]![Concern2].Visible = [HasConcern].Value
....

I'm using similar code in my current database, and it works
fine. The tables then cannot, and should not be linked
using the [HasComplaint] field.

I hope this helps you as well. Cheers

Chris