Update Radio Button Option Group based on Combo Box selection

[xuanb]

Hi,
How do I update a group of radio buttons based on a selection in a combo box.

My code doesn't work. Please give advice.

Me.option_group.ControlSource = "SELECT OGValue FROM MyTable" & _
" WHERE MyTable.ComboBoxValue = '" & Me.ComboBoxValue & "';"

Your help is much appreciated!
xuanb

 

[Isadore]

xu: Try referencing the combo box like:

Me.cboTest.Column(0)

...see if that helps.

 

[Trendsetter]

I'm assuming that the combo's bound column is 1 and that in that column is the value of the radio buttons you wish to reference.

Me.OptGroup.Value = Me.cboButtonSelect
All of the radio buttons will have avalue within the option group and the combo needs to reflect that value.
don't forget to requery the option group after_update