corinereyes
New member
- Local time
- Today, 09:55
- Joined
- Mar 3, 2013
- Messages
- 12
Code:
Dim cmb As String
Dim evaltype() As Variant
Dim f1 As Integer
Dim f2 As Integer
cmb = cmbContractType.Text
f1 = Me.Frame112.Value
f2 = Me.Frame134.Value
If cmb = "Medical" Then
Select Case evaltype(f1, f2)
Case evaltype(1, 1)
DoCmd.OpenReport "Medical", acViewReport
End Select
End If
Hello Everyone!
I'm trying to get the values in frame 1 and frame 2 (they are group of option buttons separated by frames). I have used select case statements because they will be a lot of scenarios. Basically if a user selects option button 1 (frame1) and option 1 (frame2) a report will be displayed. However i can/t get it work. Type mismtach or subscript out of Range .
Any shed of light will help me a lot. Thank you.