Option Group Mods

[Homer]

i have created an option group with about 15 choices(buttons). This data base
is very big with 5 similar option groups on different forms. now i need to
add two more options to each option group. is there any way to do this
without recreating the whole option group(lots of vba code involved). each
option group has buttons when clicked on opens a corresponding form. My
nightmare!

 

[Klatuu]

Well, for starters, maybe an option group was not the right control to use
for this, but, to answer your question, all you need to do is expand the
frame large enough to include your two new options. Then drap an option
button control for each into the frame.

 

[Linq Adams via AccessMonster.com]

As Klatuu suggested, an Option Control is probably not the control of choice
when there's 15 or motre choices! A combobox would probably be better suited.

 

[John W. Vinson]

i have created an option group with about 15 choices(buttons). This data base
is very big with 5 similar option groups on different forms. now i need to
add two more options to each option group. is there any way to do this
without recreating the whole option group(lots of vba code involved). each
option group has buttons when clicked on opens a corresponding form. My
nightmare!

I've rarely used option groups for this very reason: they are not data
dependent and cannot be made data dependent.

An alternative that you might want to consider is a single-select Listbox. The
appearance is different, and may require some hand-holding for users familiar
with the existing interface, but at least the listbox will simply and
naturally add new options, simply by adding a record to its rowsource, and the
code to open a form based on selecting a row in the listbox is even simpler
than that using an option group (you can actually store the formname in the
rowsource table and simply open it, without any SELECT CASE or other
"choosing" code).

You can add new button controls to an existing option group, though. Select
one of the existing buttons; type Ctrl-C to copy it; and then Ctrl-V to paste
it within the option group control. You'll need to change its caption and
value to the desired new ones.

John W. Vinson [MVP]

 

[Homer]

I've rarely used option groups for this very reason: they are not data
dependent and cannot be made data dependent.

An alternative that you might want to consider is a single-select Listbox. The
appearance is different, and may require some hand-holding for users familiar
with the existing interface, but at least the listbox will simply and
naturally add new options, simply by adding a record to its rowsource, and the
code to open a form based on selecting a row in the listbox is even simpler
than that using an option group (you can actually store the formname in the
rowsource table and simply open it, without any SELECT CASE or other
"choosing" code).

You can add new button controls to an existing option group, though. Select
one of the existing buttons; type Ctrl-C to copy it; and then Ctrl-V to paste
it within the option group control. You'll need to change its caption and
value to the desired new ones.

John W. Vinson [MVP]

thanks for all the replys. to better explain i used the option group
designing a user interface for all the different forms and reports. it
doesn't really have anything to do with data. when an option button is
selected it opens the correct form or report and closes the one the was
presently open. the new opened form has the same option group so the user can
continue with other forms as needed. as a result it is a very user friendly
interface for a very large data base. I tried enlarging the control box
copying and pasting a button. I can program the button to work but it is just
a button not part of the option group. I will try the ctrl-v to see if it
makes a difference.

 

[Homer]

thanks for all the replys. to better explain i used the option group
designing a user interface for all the different forms and reports. it
doesn't really have anything to do with data. when an option button is
selected it opens the correct form or report and closes the one the was
presently open. the new opened form has the same option group so the user can
continue with other forms as needed. as a result it is a very user friendly
interface for a very large data base. I tried enlarging the control box
copying and pasting a button. I can program the button to work but it is just
a button not part of the option group. I will try the ctrl-v to see if it
makes a difference.

Ctrl-C and Ctrl-V is the solution thank you all for the help!