Open report filter from form getting error message

[TinaCa]

This so easy but I keep getting a weird error message.



Here is the code to open the report.

DoCmd.OpenReport "rptCrewCompanies", acViewPreview, , [CrewMemberId] = Me.cboWorker.Column(0)

I get the error message -

....can't find thefield '|1' referred to in your expression.

I should mention if i change [] to " " the report returns no records.

I swear folks I can't find |1 anywhere

[ssanfu]

Try

DoCmd.OpenReport "rptCrewCompanies", acViewPreview, , "[CrewMemberId] =  " & Me.cboWorker.Column(0)

if Me.cboWorker.Column(0) is a number. If it is text, try

DoCmd.OpenReport "rptCrewCompanies", acViewPreview, , "[CrewMemberId] =  '" &  Me.cboWorker.Column(0) & "'"