Like Statement

[kbreiss]

I'm attempting to do a LIKE statement from user input on a form. So basically the user would put part of name in a text box and do a search on it. I can't get the like statement to work. Please help.



SELECT dbo_COPYWORK_INFO.*
FROM dbo_COPYWORK_INFO
WHERE dbo_COPYWORK_INFO.NAME LIKE "'*" & [Forms]![frmDLNSearch]![txtDLN] & "*'";

Thanks in advance.
________
COCAINE REHAB FORUM

 

[Brianwarnock]

Remove the single quotes.

Brian

 

[kbreiss]

Thank you...Wish I would have posted that earlier....I tried for two hours.
________
AdorableBrina