I'm having a problem coding a button that uses option buttons as criteria. The first option button is called ReportToggle, and the second is called GraphToggle. For some reason I can't pull up the value in ciode....This is what I have so far....
Private Sub Command145_Click()
If Me.ReportToggle.Value = True Then
If Me.GraphToggle.Value = True Then
MsgBox ("Please Select Report Type: Report or Graph!"), vbOKOnly, "Report Error"
MsgBox ("This is a report.")
MsgBox ("This is a graph.")
If the option buttons are included in an option group you cannot do that. In this case, every option button has a value (1,2,3, etc.) and you have to test the value of the option group itself to know which option button is "on". The value of the option group will change and take the value of the option button you click on.