I am trying to open a report based on a where clause depending on what the user selects in an optionframe on a form.
I have looked through here and google but I am getting more and more confused.
It works if I select an option with a single number behind it, but not with the two numbers. (the numbers are primary keys for the customers).
Any help is appreciated.
Dim strWhere As String
Dim Cust As Integer
Select Case Me.frameProdGroup
Cust = 300 Or 169
Cust = 444 Or 329
Cust = 238
Cust = 220
Cust = 235
Cust = 180
strWhere = "[fkCustID] = " & Cust
DoCmd.OpenReport "rptStoxBase", acViewReport, , strWhere