Option Group On-the-fly?

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

Guest

Is it possible to make an option group change options (including the number
of items) according to a query?

Failing that, what is the most straightforward way to emulate such a feature
in Access 2000? The idea is for the list of items to change, as in a list
box, for example, but to appear to be an option group with radio buttons.

Thanks in advance.
 
Is it possible to make an option group change options (including the number
of items) according to a query?
Click to expand...

Not at all easily. You'ld need to open the Form in design view, add or
subtract new controls within the option group, reset the option
group's properties, etc. etc.
Failing that, what is the most straightforward way to emulate such a feature
in Access 2000? The idea is for the list of items to change, as in a list
box, for example, but to appear to be an option group with radio buttons.
Click to expand...

A continuous Subform based on the query, with a command button or
radio button control, with code in the control's Click event to take
the needed action.

John W. Vinson[MVP]
 
David Habercom said:
Is it possible to make an option group change options (including the
number of items) according to a query?

Failing that, what is the most straightforward way to emulate such a
feature in Access 2000? The idea is for the list of items to change,
as in a list box, for example, but to appear to be an option group
with radio buttons.
Click to expand...

You could create the option group with the maximum possible number of
options, and then at run time make various option buttons visible or
invisible as needed, modify the label captions, move the buttons and
labels around as desired, and resize the group frame. It would be
cumbersome, but it could be done.
 
Back
Top