Here's a brute force method that works:
Code:
Option Compare Database
Option Explicit
Private Sub cmdOpenReport_Click()
Select Case fraOrgSpec.Value
Case 1
Select Case fraCountry.Value
Case 1
MsgBox "run report for spec1, UK"
Case 2
MsgBox "run report for spec1, US"
Case 3
MsgBox "run report for spec1, Canada"
End Select
Case 2
Select Case fraCountry.Value
Case 1
MsgBox "run report for spec2, UK"
Case 2
MsgBox "run report for spec2, US"
Case 3
MsgBox "run report for spec2, Canada"
End Select
Case 3
Select Case fraCountry.Value
Case 1
MsgBox "run report for spec3, UK"
Case 2
MsgBox "run report for spec3, US"
Case 3
MsgBox "run report for spec3, Canada"
End Select
End Select
End Sub