combo box to call option group

[yosh]

Hello All,

I'm pretty new at this so please be patient. I am a Mechanical
contractor, putting together a database of boiler rooms for my client.

Here's my issue:

I would like to use a combo box selection to call on an option group.
I will have three values to choose from in my combo box. Each value in
the combo box will cause a different option group to appear.

Should I create three different option groups and just turn the
visible property to true if the value is selected, or is there a
better way to do this??

Thanks,

Josh W

 

[Dale Fye]

That would be one way to do it.

Another way would be to use a second combo box that uses the value from the
first combo as part of the query which is it's basis. Then, in the
AfterUpdate event of the first combo, you would requery the 2nd combo. This
is easier to construct, and much more flexible as it gives you the ability to
change your options much easier than if you use an option group.

If you choose the latter option, and need assistance, post back with a few
more details.


HTH
Dale

 

[Klatuu]

There are a bunch of maybes here.
Without knowing all the detail, it is not possible to give an exact answer,
but one way would be to make all 3 option groups invisible and use the After
Update event of the combo to make the appropiate option group available.
Another way would be to use one option group and change the number of
options and the captions based on the combo selection. The main issue is
whether these option groups are bound controls or not. How the option groups
are used could also influence your decision.