Changing Options In A Group

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

The options for each pushbutton in the group are enumerated. I cannot find
where they are. I would like to have them based on a table rather than
being enumerated.

I see that I can change the labels but I need the table anyway to get the
values to a report. Is there some way that I can get the values for the
report from my enumeration?

Bob
 
I am not sure what you mean by basing them on a table.
Option groups are not necessarily enumerated. Each option button has an
Option Value property it returns to the Option Group when it is selected.
The Option Value proerty is a long integer, but it is not required they by
sequental in numbering, you could have Option 1 = 12, Option 2 = 5, and
Option 3 = 982.
If you bind a field to an option group on your form, it will either set or
get the value of the option group.
 
By enumerated, I mean in the first step of the wizard you make a list of the
names like red, green and blue for each button in the group. I want these in
my report based on the field I have selected not the value that is stored.
I've made a duplicate table with the names and values that are in the group.
My report is based on this. It would be easier to have only the table where
the button names are on the pushbuttons and the value that is stored in the
bound table is the corresponding value.

Bob
 
Back
Top