{Unsolved} How to create "Option Group" bounded to table?

[wecka]

Does any one know to bound the choices of an option group to a table. Table structure is ID, Text which shall map to Text, Value for the radio buttons repectively.

Appreciate advice.

- Hany

[MMcCarthy]

Does any one know to bound the choices of an option group to a table. Table structure is ID, Text which shall map to Text, Value for the radio buttons repectively.

Appreciate advice.

- Hany

You can't really do it other than to manually enter the values corresponding to each ID in the value property of each option and to set the labels accordingly. You can of course then store the selected option in a particular field by setting the control source of the option frame.

[wecka]

Thanks for the quick response. It is a bit frustrating that it is not easy/feasiable.

Here is my problem anyways, and I am open for your input. I want to create a customised report. Each sentence is completed according to a slected option from each option group (a group for every question). I want the user to be able to update the values (options) for each question, and have that automatically reflected on the form (loading the stored options).

Do you think there can be a way?

- Hany

[MMcCarthy]

Thanks for the quick response. It is a bit frustrating that it is not easy/feasiable.

Here is my problem anyways, and I am open for your input. I want to create a customised report. Each sentence is completed according to a slected option from each option group (a group for every question). I want the user to be able to update the values (options) for each question, and have that automatically reflected on the form (loading the stored options).

Do you think there can be a way?

- Hany

Would combo or list boxes not work better?

[wecka]

By the way, on Microsoft website, there is that page
http://office.microsoft.com/en-us/ac...CH063661981033. it talks about a bounded option group somewhere in the middle, but i cant not reproduce it. The field list is not shown (since the form is not bounded to a table).

Even if the form is bounded to a table, still I would have a table for each question, and I do not think there is a way to get a form bounded to multiple source :(

[wecka]

Combo/lists is not really a good solution. The one who will be using the application of very low tech background, and it is needed to have all the options appearing "in full" when selecting.

[MMcCarthy]

Combo/lists is not really a good solution. The one who will be using the application of very low tech background, and it is needed to have all the options appearing "in full" when selecting.

I'm afraid I don't know what else to suggest. Maybe someone else will have an idea.

[wecka]

I'm afraid I don't know what else to suggest. Maybe someone else will have an idea.

Thanks mmccarthy. I definately appreciate your help.

[NeoPa]

Is it not simply to set the Control Source of the frame to a field in your dataset.
A frame will always be assigned a value depending on the button selected.
When assigning a frame to a field it is a good idea to ensure that there is an option button set for each possible value in the current data.