By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,455 Members | 1,979 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,455 IT Pros & Developers. It's quick & easy.

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

P: 8
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
Nov 13 '06 #1
Share this Question
Share on Google+
8 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
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.
Nov 13 '06 #2

P: 8
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
Nov 13 '06 #3

MMcCarthy
Expert Mod 10K+
P: 14,534
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?
Nov 13 '06 #4

P: 8
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 :(
Nov 13 '06 #5

P: 8
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.
Nov 13 '06 #6

MMcCarthy
Expert Mod 10K+
P: 14,534
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.
Nov 13 '06 #7

P: 8
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.
Nov 13 '06 #8

NeoPa
Expert Mod 15k+
P: 31,186
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.
Nov 13 '06 #9

Post your reply

Sign in to post your reply or Sign up for a free account.