Error when running an sql statement

[str8trini]

I am trying to run an sql statement as the source for this recordset and I
keep getting the message "No value given for one or more required
parameters". Can someone tell me what I am missing? I've been looking at
this for hours and it probably is going to be something very simple as usual,
but any help will be appreciated. Thanks!

With rsDupCk
If rsDupCk.State = adStateOpen Then
.Close
End If
.Source = "SELECT tmpAllCallsAM.NICE_ID, tblMasterAM.TM,
tblMasterAM.Reviewer_ID, tblMasterAM.NICE_ID" & vbCrLf & _
"FROM tmpAllCallsAM INNER JOIN tblMasterAM ON
tmpAllCallsAM.NICE_ID=tblMasterAM.NICE_ID" & vbCrLf & _
"WHERE (((tblMasterAM.TM)='Calibration, AM') And
((tblMasterAM.Reviewer_ID)=[Forms]![frmCalibrationAM]![txtReviewer]))"
.Open

 

[str8trini]

As usual it was something small that I overlooked and just had to get away
for a while. I had to identify the form field as text as was the table data.
This is my correction that worked:

And ((tblMasterAM.Reviewer_ID)='" & Me![txtReviewer] & "'" & "))"