Data Type Mismatch in Crit Expression

[Scott Oh]

I have a field in my query titled "Exposure" with a criteria of "HFA". No problem running the query. However, I needed to get more out of my output and changed "Exposure" to "Exposure: DLookUp("exposure","tblReviewDetail","[tblReviewDetail].[ReviewName]='" & Replace(tblCusip!ReviewName," ' "," ' ' ") & "'")" with the same criteria of "HFA". Now when I run this query I get the message of "Data Type Mismatch...". Keep in mind that the only alteration was the dlookup. I'm stumped! Any help please.

 

[Guus2005]

Please feel free to submit the actual query because your question raises more questions