Search queri social security number

[mickelingon]

HI

I have a query that looks like this:
Like [Forms]![Searchaddress_form]![search_3] & "*"
The filed name is "ssn"

In a form I have an unbound field that is called "search_3" and when I type a number or more and hit enter it's supposed to look it up in the table. But it´s not working

FYI! It works whith letters. I have the same query for searchin first name and it works.
But not with numbers.

Any suggestions?

//Mikael

 

[RuralGuy]

I could be wrong but I believe Like is for text only since it does not really make much sense otherwise. Try using CStr() the field and see if you get the results you need.

 

[mickelingon]

Ok, should I write CStr() ssn (name of the table filed) and that should do it?
Or should I use some of the code I wrote Like [Forms]![Searchaddress_form]![search_3] & "*"

Thanks

 

[RuralGuy]

Did you look up CStr() in VBA help?