DoCmd.OpenReport (from combobox)

[Access_Help]

DoCmd.OpenReport sRpt, acPreview, , "[First_Name]= '" & List13.Column(1) & "'" And [Progress] = "Me.[Combo26]"

Can someone please help me fix the syntax error in this line.

I have a form with a listbox and a combo.

I have added the second search criteria And [Progress] = "Me.[Combo26]",

I am recieving a run time error 2465 - can't find the field '1' referred in your expression.

The first search criteria from the listbox works fine.

Thanks in advance.

 

[MajP]

I am guessing there is no field called Progress in your report. Fields are zero based.

 

[Minty]

You haven't concatenated the string correctly, try this; (I've assumed Progress is a text field, if not remove the additional ' ' around combo26 value).

Dim sWhere as String

sWhere =  "[First_Name]= '" & List13.Column(1) & "' And [Progress] = '" & Me.[Combo26] & "'"

Debug.Print sWhere

DoCmd.OpenReport sRpt, acPreview, , sWhere