Option button linked with combo box

[petercummins]

Morning folks,

Todays problem is as follows!...

Is there away to set the values in a combo box depending on what option button you have selected.

What I would like is to select an option button in an option group then that would trigger certain vaules in a combo box. And if I selected another option button it would change the values in the same combo box?

So if I selected optWhite, the values in cboEthnic = British AND Irish AND Other

If I select optMixed, the values in cboEthnic = White and Black Asian AND White and Black Caribbean etc...

Hope this makes sense.

 

[ansentry]

Use 2 combo boxes instead of Option and combo - search for cascading combox boxes, you will find plenty of examples here.