Option Button If-Then statements

[dccjr]

I am having an issue with an If-Then statement that is based on the selection of an option (radio) button. The radio buttons are named: rdoSingle and rdoCompleteSet. They are in a frame named: SearchOptions. I keep getting " Run-time error:2427 You entered an expression that has no value." on the If statement.

Here is the code:



If rdoSingle.Value = True Then
Select Case Me.cboFieldID.Value
Case "Work Order #"
strSQL = "SELECT RCAData.[WorkOrderNo] FROM RCAData ORDER BY RCAData.[WorkOrderNo] ASC;"
DoCmd.RunSQL strSQL
Me!cboIDNo.RowSource = strSQL

It contains several more Case statements. Do I need to declare the buttons or group somewhere. If so, how? I can't find anything useful searching google. Any help would be greatly appreciated.

[pbaldy]

If they're in a frame, you test the value of the frame, not the options within.

[dccjr]

Thanks, but I am completely new to this. What would be the syntax for the If statement to determine which button is selected?

[pbaldy]

Each button has an "Option Value" property. The value of the frame will be the Option Value of the selected option (or Null, if nothing has been selected). By default they'll be numbers 1-x, but that can be changed.

[dccjr]

Thank you so much for your help. Got it fixed.

[pbaldy]

Happy to help!