Multi Criteria to run Reports 1

[ZeoGel]

I am tring to create a report with multiple criterias from a form. I have tried this code but keep getting a " missing operator error" with can someone show me where iam going wrong?

Private Sub Command7_Click()
On Error GoTo Err_Command7_Click

Dim stDocName As String
Dim stLinkCriteria As String

stLinkCriteria = "[Class]=" & Me![Class] & " AND [Manager]= " & Me![Manager]


stDocName = "rptExamsavg"
DoCmd.OpenReport stDocName, acPreview, , stLinkCriteria
Exit_Command7_Click:
Exit Sub

Err_Command7_Click:
MsgBox Err.Description
Resume Exit_Command7_Click

End Sub

 

[HarleyQuinn]

If Class and/or Manager are text fields you'll have to wrap the criteria values in double quotes (or Chr(34) which is probably easier).

Hope this helps

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[ZeoGel]

I have tried it and get the same error missing operator.

But thanks for the suggestion.

 

[HarleyQuinn]

Could you show what you tried that didn't work?

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[ZeoGel]

here is what i did

stLinkCriteria = ("[Class]=" & Me![Class] & " AND [Manager]= " & Me![Manager])

 

[HarleyQuinn]

Ah, I see. I meant double quotes, something more like:

stLinkCriteria = "[Class]=" & Chr(34) & Me![Class] & Chr(34) & " AND [Manager]= " & Chr(34) & Me![Manager] & Chr(34)

Hope this helps

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[ZeoGel]

Sweet!!!!!! You Rock! Thank you for the help it has only been a week i have been trying to get this to work.


Very Appreciative of your Assistance
Ron.

 

[HarleyQuinn]

Glad I could help, thanks for the star

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[HarleyQuinn]

Oops, sorry. I typed that on autopilot!

Glad I could help anyway

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.