Help with a string where the field is text not numeric 1

[WallT]

I have a filter I am using on a form. I am not very savoy with sql, but I am sure the problem with the following string is that "ActivityDetailsID" is a text property. Can somebody help me change this please? Thank you.


strFilter = "ActivityDetailsID = " & Me!ActivityDetailsID

 

[PHV]

strFilter = "ActivityDetailsID = [tt][!]'[/!]"[/tt] & Me!ActivityDetailsID [tt][!]& "'"[/!][/tt]

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[WallT]

Works perfect...I can never remember how to do that...thank you!