Ok so I'm a casual VB6 programmer and now I'm VBA for Access. In VBA I am trying to determine if whether an option button has been pressed. I used the 'Option1.Value' procedure yet it throws a 'You entered and expression that has no value' error.
Here's my code:
Dim stDocName As String If optEligibility.Value = 1 Then stDocName = "rptEligibiltyRoster" Else stDocName = "rptTypicalRoster" End If DoCmd.OpenReport stDocName, acPreview