Type Mismatch Error . .

[Evagrius]

Hi,

I am trying to use TWO multiselect listboxes to filter a report before opening. I get a Typemismatch error at this line.

Rem OPEN THE REPORT LIMITED TO SELECTION
  DoCmd.OpenReport "UNIQUE REPORT", acViewReport, , "[Year] IN(" & strWhere & ")" And _
"[Building] IN(" & strWhereB & ")"

What am I doing worng? strWhereA and strWhereB store the selections in a string. Thank you!

 

[boblarson]

The AND has to be within the quotes:

  DoCmd.OpenReport "UNIQUE REPORT", acViewReport, , "[Year] IN(" & strWhere & ") [B][COLOR="Red"]AND "[/COLOR][/B]  & _
"[Building] IN(" & strWhereB & ")"

 

[Evagrius]

That is perfect Bob! Thank you Sir!!