Using like to search

[SQLScholar]

Hey all,

I have a form which has a textbox on it, and a button. When the button is clicked, it runs a query which has a field based on the textbox. Its basically supposed to be a search function on one field.

Problem - i just cant seem to get to return the correct rows. For instance i type in something and i get 250 rows... whatever i type?

The query looks like this:

SELECT Log.Prefix, Log.Type, Log.Reference, Log.[Date Reported], Log.[Email of Reporter], Log.[Overview/Screen], Log.Details, Log.[Policy Number/Client Key], Log.[Resource Email], Log.Timescale, Log.Priority, Log.Position, Log.Status, Log.Resolution, Log.[Date Resolved], Log.[Resolved in/By], Log.[Original CR number], Log.[Email Address of Tester], Log.[Creation Date]
FROM Log
WHERE (((Log.Details) Like "*" & [Forms]![DetailSearch Frm]![DetailsCB] & "*"));

Any help much appreciated.

Dan

----------------------------------------
There are 2 types of computer, the prototype and the obsolete!!

 

[traingamer]

If Log.Details is text, try single quotes:

WHERE (((Log.Details) Like "[COLOR=red]'[/color]*" & [Forms]![DetailSearch Frm]![DetailsCB] & "*[COLOR=red]'[/color]"));

traingamer

 

[SQLScholar]

Sorry - ignore me, i am being dense. I chose the wrong text
box?

:-(

D

----------------------------------------
There are 2 types of computer, the prototype and the obsolete!!