VBA filter Syntax

[bleep-blop]

Hi, very quick question.

This filter vba doesnt work

Me.Filter = "abcode= " & i And "EmpASID = " & f
Me.FilterOn = True

runtime error 13 type mismatch.

Both Abcode and EmpASID are Numerical.

So is i and f

Me.Filter = "abcode= " & i

works fine on its own

Me.Filter = "EmpASID = " & f

works fine too on its own


little bit baffled lol

I cant figure out where i have gone wrong for the syntax.

any help would be greatly appreciated

 

[pr2-eugin]

You need to concatenate the String with values..

Me.Filter = "abcode= " & i [COLOR=Red][B]& " [/B][/COLOR]And EmpASID = " & f
Me.FilterOn = True

 

[bleep-blop]

Ah thank you so much always feel silly when it something that simple lol Cheers

 

[pr2-eugin]

No Problem. Good Luck.