Data Type MisMatch . .

[Evagrius]

Hi All,

I attempted several tactics but I couldn't figure this out - I keep getting the error. I am sure it's something simple. Thanks for any help!

Dim MyStr as Variant
MyStr = ">= 0.75" 
Me.Filter = "[Ratio Type] = 'Acid' And" & "[" & MyFldName & "]= " & MyStr

 

[pbaldy]

It looks like you've missed a space, which is hard to see with the extraneous concatenation. You're also going to end up with an extra equals sign. Try this:

Me.Filter = "[Ratio Type] = 'Acid' And [" & MyFldName & "] " & MyStr

That presumes that MyFldName will end up being a numeric field rather than a text field.

 

[Evagrius]

Thanks pbaldy - I left the office but I will give it a go first thing Monday - thank you for taking the time to help.

 

[Evagrius]

Hi pbaldy - I just wanted to return and say thank you! I integrated your suggestion this morning and the error is resolved. Thanks!

 

[pbaldy]

Glad it worked for you!