Apply Filter with a Number

[TedMartin]

Docmd.ApplyFilter, "Field = 6" finds the record where the data equals 6.

BUT.

Docmd.ApplyFilter, "Field = intVariable" fails.

I have tried all sorts of other syntax.

Help please.

Thanks

Ted

 

[Jon K]

DoCmd.ApplyFilter , "Field =" & intVariable
.

 

[TedMartin]

Thank you

So easy too.