Questionaire

WindowsXP, AccessXP

I need to create a continuous form for entering responses to a questionaire
like so:
Question Response
The responses can be Yes/No, Text or a selection from a combobox. Can anyone
suggest a way to make the form self maintaining so that a textbox appears
for the questions where text is entered, an option group appears for
questions where a Yes/No is entered and a combobox appears for questions
where the user must select an answer from a list? And for the comboboxes,
they would need different rowsources for different questions. How would this
be done?

Thanks,

Tom

re: Questionaire

On Mon, 16 May 2005 12:15:02 GMT, "Tom" <NotMy@email.com> wrote:

Use a tab control to lay out the 3 types. Then as the user moves from
question to question, the Form_Current event occurs, and you display
the correct tab. You can turn off the display of the actual tabs, for
a more integrated look.

-Tom.

[color=blue]
>WindowsXP, AccessXP
>
>I need to create a continuous form for entering responses to a questionaire
>like so:
>Question Response
>The responses can be Yes/No, Text or a selection from a combobox. Can anyone
>suggest a way to make the form self maintaining so that a textbox appears
>for the questions where text is entered, an option group appears for
>questions where a Yes/No is entered and a combobox appears for questions
>where the user must select an answer from a list? And for the comboboxes,
>they would need different rowsources for different questions. How would this
>be done?
>
>Thanks,
>
>Tom
>[/color]

re: Questionaire

Tom,

Thanks for your response!

I follow you; however, won't the responses all have the same type of control
when the form opens, ie, all textboxes for example? Then when the user goes
to a record needing a combobox, wouldn't the controls for all questions then
change to a combobox? Is there any way to have different controls for
different questions when the form opens? I was looking at the Developers
Handbook and Getz has a way to do it in reports in the detail format event.

Tom


"Tom van Stiphout" <no.spam.tom7744@cox.net> wrote in message
news:817h811gqh0g6hp7osfudjdjt7oetla76b@4ax.com...[color=blue]
> On Mon, 16 May 2005 12:15:02 GMT, "Tom" <NotMy@email.com> wrote:
>
> Use a tab control to lay out the 3 types. Then as the user moves from
> question to question, the Form_Current event occurs, and you display
> the correct tab. You can turn off the display of the actual tabs, for
> a more integrated look.
>
> -Tom.
>
>[color=green]
> >WindowsXP, AccessXP
> >
> >I need to create a continuous form for entering responses to a[/color][/color]
questionaire[color=blue][color=green]
> >like so:
> >Question Response
> >The responses can be Yes/No, Text or a selection from a combobox. Can[/color][/color]
anyone[color=blue][color=green]
> >suggest a way to make the form self maintaining so that a textbox appears
> >for the questions where text is entered, an option group appears for
> >questions where a Yes/No is entered and a combobox appears for questions
> >where the user must select an answer from a list? And for the comboboxes,
> >they would need different rowsources for different questions. How would[/color][/color]
this[color=blue][color=green]
> >be done?
> >
> >Thanks,
> >
> >Tom
> >[/color]
>[/color]

re: Questionaire

On Mon, 16 May 2005 13:26:49 GMT, "Tom" <NotMy@email.com> wrote:

I was imagining a program that is showing one record (question) at a
time. Apparently you're thinking continuous form or datasheet, where
my suggestion doesn't work.

-Tom.

[color=blue]
>Tom,
>
>Thanks for your response!
>
>I follow you; however, won't the responses all have the same type of control
>when the form opens, ie, all textboxes for example? Then when the user goes
>to a record needing a combobox, wouldn't the controls for all questions then
>change to a combobox? Is there any way to have different controls for
>different questions when the form opens? I was looking at the Developers
>Handbook and Getz has a way to do it in reports in the detail format event.
>
>Tom
>
>
>"Tom van Stiphout" <no.spam.tom7744@cox.net> wrote in message
>news:817h811gqh0g6hp7osfudjdjt7oetla76b@4ax.com.. .[color=green]
>> On Mon, 16 May 2005 12:15:02 GMT, "Tom" <NotMy@email.com> wrote:
>>
>> Use a tab control to lay out the 3 types. Then as the user moves from
>> question to question, the Form_Current event occurs, and you display
>> the correct tab. You can turn off the display of the actual tabs, for
>> a more integrated look.
>>
>> -Tom.
>>
>>[color=darkred]
>> >WindowsXP, AccessXP
>> >
>> >I need to create a continuous form for entering responses to a[/color][/color]
>questionaire[color=green][color=darkred]
>> >like so:
>> >Question Response
>> >The responses can be Yes/No, Text or a selection from a combobox. Can[/color][/color]
>anyone[color=green][color=darkred]
>> >suggest a way to make the form self maintaining so that a textbox appears
>> >for the questions where text is entered, an option group appears for
>> >questions where a Yes/No is entered and a combobox appears for questions
>> >where the user must select an answer from a list? And for the comboboxes,
>> >they would need different rowsources for different questions. How would[/color][/color]
>this[color=green][color=darkred]
>> >be done?
>> >
>> >Thanks,
>> >
>> >Tom
>> >[/color]
>>[/color]
>[/color]