option group

[Guest]

is it possible to have an option group call another option group?

i have an option group on a form with check boxes. when a check box is
selected, a specific value is placed in a text box that is not shown. that
value is used in a query as a selection item.

i have another option group that is primarily a subset of the first. i do
the same thing as above and that new variable is another selection item in
the query.

i do not want a lot of option groups on the form and was wondering if it
were possible to do some type of 'drop down' with option groups

thanks for your help

 

[George Nicholson]

Consider using single-select list boxes instead.
1) no need for a separate text box to hold the result, you can get it
directly from the listbox
2) changing the selection in listbox A can drive the choices available
in list box B

HTH,