multiple criteria for report VBA?

[pablavo]

Hi folks

I borrowed some code to use with reports which is:

If Not IsNull(Me.cboProjectCode) Then
strWhere = strWhere & "[ProjectID]=" & Me.cboProjectCode & " And "
blnTrim = True

Before that I used a technique using a dynamic query by code but this is a lot easier.

My question is. If the field was a text field and not a numeric ID field as above. do you know what the syntax would be? I keep getting type mismatch and so on!

Thanks

 

[pbaldy]

Note the added single quotes:

strWhere = strWhere & "[ProjectID]='" & Me.cboProjectCode & "' And "