Posible to make a hybrid Option Group w/ Combo Box?

[RickDB]

Hey all, I am wondering if there is a way to do this:

Create an Option Group from a list (the Option Group would be most popular responses), and then, using the same control list in a table, have a combo box for the other possible entries?

Whatever is selected, it would be stored to one table to prevent reduncy... This would be strictly to expidite data entry.

Thanks for any replies in advance...

 

[RickDB]

Can anyone take a shot at this please? It would be appreciated, if even a not possible was given.

Thanks!

 

[Banana]

I'm not seeing any advantage of doing this?

The purpose of option group is to ensure that user make only one selection from several radio buttons or few selections from some checkboxes, which those are assigned a integer value and using Select Case block, determine what code to execute.

If you're using it to save a value into a record, that's not what it is for. A listbox or a combobox will do that just fine on their own..

Unless I'm not understanding something?

 

[pbaldy]

What's the question? It's certainly possible. If both the frame and the combo are bound to the same field, they will stay in sync (if you make a selection in one it would be reflected in the other).

Edit: Sorry Banana, your response wasn't there when I started typing.

 

[RickDB]

Ehh, maybe it is a bad idea...

I was thinking, say there are 10 options in a list, but 90% of the time, only 2 of those will be used. I was thinking have 3 radial buttons... 1 for "Other, if other was selected, they would have to select one of the uncommon values from a drop list.

After thinking about it, this may be counterintuitive, but given the rarity of the other 8 options, I thought maybe it would make entry easier.

Thanks for the replies, I think a combobox will do.

 

[Pat Hartman]

If you have the screen real estate, you might try a listbox. It will show all ten options so the effect is the same as the option group.

 

[Banana]

pbaldy, No need to apologize; if you hadn't posted, I wouldn't know that was actually possible. May be useful... if I find a use for it.