Where Condition

[livvie]

I want to run a different report depending on 2 conditiond being true - how do I do this. I can get it working with one condition but how do I AND the conditions. Here is what I tried and I am getting a type mismatch error.

strCondition = "[confirm] = 1" And "[id]= " & Me!fsubQuoteList![id] & ""

DoCmd.OpenReport stDocName, acPreview, , strCondition

 

[Mile-O]

strCondition = "[confirm] = 1 And [id]= " & Me.fsubQuoteList![id]

 

[livvie]

Spot on. What would I do without ye.