Varying a control type on a subform - based on record criteria.

[LeeTV]

Question: How do I get my subform to show different control (based on each of the subform's record criteria)
I have a survey database (MS ACCESS), that asks a student to evaluate a course by asking defined questions, the questions are different for each course.
Currently the subform shows only a combobox where the student enters their response. What I would like to achive is to have an appropriate control based on the question type. i.e. if the question elicits a yes/no response then i'd like to have 2 radio buttons (Yes and no) that allows the student to answer. The problem i'm having is that i can put a radio button on the subform (or whatever control is desired by the questions response), but it shows as a radio button for ALL rows (Other rows may require a Check box answer, combobox, or free text).
I attempted overlaying all the control types and setting the property to visible=false (based on the response control criteria), but it showed the same control for every record.
Below is a small example of what i would like to accomplish.
e.g.
Parent form = Survey name / Date completed / etc.
subform (contains questions)

1 What time did you arrive today [control = textbook]
2 Did you take the pre-course test? [control = radio button -yes/no]
3 I found the course to be: [cbobox = excellent, good, fair, bad] etc..
some of the surveys have 30-40 questions.


THanks
Lee

[ItsMe]

If you are using bound controls, the control should match the data type of the field in the table.

If you are using unbound controls to collect User input, you may find the .Visible property beneficial.

[June7]

LeeTV, that is normal behavior for bound forms and normalized data structure and really can't be altered. Changing the properties of a control will be reflected in all records. Period.