open report based on address

[edaddyj]

Hello, I have a db that tracks Jobs that our company does. Each job has a unique JobID. I have a report that groups all my jobs by JobStreetAddress. Since some jobs may be at the same address I want a command button in my Jobs form that opens my report (repair report) just showing the jobs with that address. Here is what I have that isn't working:

Private Sub Command157_Click()
On Error GoTo Err_Command157_Click

Dim stDocName As String

stDocName = "Repair Report"
DoCmd.OpenReport stDocName, acPreview, , "[JobStreetAddress]=" & [JobStreetAddress]

Exit_Command157_Click:
Exit Sub

Err_Command157_Click:
MsgBox Err.Description
Resume Exit_Command157_Click

End Sub

The syntax error reads "Syntax error (missing operator) in query expression '([JobStreetAddress]=1390 S. Cooper st.)'.
It recognizes the address in whatever form I am in but I don't understand what to do now. please help.

[MMcCarthy]

Try this ...

 
DoCmd.OpenReport stDocName, acPreview, , "[JobStreetAddress]='" & [JobStreetAddress] & "'"
 

Mary