Using Access for a Survey

[jsinc01]

I want to design a form for patients to complete.
It must be straightforward and easy for people with limited IT experience.
Most of the questions take the format:
"Do you get <whatever problem>" with a choice of answers as follows
Frequently, Occasionally, Never.

I thought of using a drop down box, but that means they have to press an arrow to see the options. I would prefer them to be able to see the three options with a simple button next to each - to allow patients to think about the options before selecting just one.

I dont want them to be able to select two or more of the possible options.

I am really trying to make a very standard type of survey form, but there isnt any sort of wizard setting that lets you do this.
Can anyone help?

 

[Mr. B]

Have you considered using an Option Group. You can have as many option groups as need and have as many options in each group as needed. The opton group will only allow one option to be selected in each group. The option group can be bound to a field in your table and it will store a numeric value for the selected item.

 

[jsinc01]

Mr B.
Many thanks for taking the time to post a reply. I will have a look at the option groups and see if that solves the problem. Thanks once again. J

 

[jdraw]

You may wish to review the info here
http://www.rogersaccesslibrary.com/forum/topic3.html

This is an often referenced utility.

Good luck.

 

[jsinc01]

Thanks for posting this link. It is amazing what can be done with Access. For my questionnaire, I think Option groups may be sufficient. The only down side being the limitation to a numerical selection. Thanks again for taking the time to respond. J