REPOST - Option Group Visibility

[Guest]

I have used option group in a continous form. The ideal design is that users
are able to see the followings: 1) Strongly Agree, 2) Agree, 3) Disagree, 4)
Strongly Disagree for multiple choice type of questions; 1) Yes, 2) No for
Yes/No type of questions; and, a textbox instead of an option group for
comment-only type of questions.

So far, I have 6 choices on the form: 1) Strongly Agree, 2) Agree, 3)
Disagree, and 4) Strongly Disagree, 5) Yes, 6) No, and a textbox for comments
for every question no matter which question type the question belongs to.

I want to make choices visible ONLY for certain type of questions but it
seems that the choices (optional group & Textbox) have to appear for all
question type. Please help! Thanks * 100000

 

[Guest]

thank you. Sounds like it will work. Let me try that out

Yes, frequently the limitation of a continuous form is that a control's
property only exists once for ALL records; it cannot have a different state
for each record. You could, however, create three controls--two option
groups and one textbox, and set the Enabled property in the On Current event
procedure based on the question type, which I assume is a field in the
RecordSource of the continuous form. Then, you will *see* all responses, but
only be allowed to choose from the appropriate control:

Select Case Me![QuestionType]
Case "Agree/Disagree" ' or 1, or whatever QuestionType value
corresponds
Me![AgreeOptionGroup].Enabled = True
Me![YesNoOptionGroup].Enabled = False
Me![YourTextbox].Enabled = False
Case "YesNo"
Me![AgreeOptionGroup].Enabled = False
Me![YesNoOptionGroup].Enabled = True
Me![YourTextbox].Enabled = False
Case Else
Me![AgreeOptionGroup].Enabled = False
Me![YesNoOptionGroup].Enabled = False
Me![YourTextbox].Enabled = True
End Select

Hope that helps.
Sprinks

I have used option group in a continous form. The ideal design is that users
are able to see the followings: 1) Strongly Agree, 2) Agree, 3) Disagree, 4)
Strongly Disagree for multiple choice type of questions; 1) Yes, 2) No for
Yes/No type of questions; and, a textbox instead of an option group for
comment-only type of questions.

So far, I have 6 choices on the form: 1) Strongly Agree, 2) Agree, 3)
Disagree, and 4) Strongly Disagree, 5) Yes, 6) No, and a textbox for comments
for every question no matter which question type the question belongs to.

I want to make choices visible ONLY for certain type of questions but it
seems that the choices (optional group & Textbox) have to appear for all
question type. Please help! Thanks * 100000