LIKE function

  • Thread starter Thread starter Chad
  • Start date Start date
C

Chad

I posted this in another section and no one was bale to
help me. I've always gotten good responses from this
room so if anyone could help me I would really appreciate
it.

I don't know if I am overlooking something obvious or not
but if anyone could help me I would really appreciate
it. I would like to display records that resemble
criteria entered into a textbox. Access doesn't recognze
the SOUNDEX or % functions and the LIKE function only
allows you to enter values in quotations, so if I enter:

SELECT FName, LName
FROM tblRequest
WHERE FName Like "*Forms!frmSearch!txtFName*"

the query looks for the string "Forms!frmSearch!txtFName"
which of course isn't in my table. My question is if
there is a way to look for records that resembled data
entered into a control on a form. And if so, how to you
specify that in SQL?

Thanks in advance,
Chad
..
 
Hi,
Try something like this:
SELECT FName, LName
FROM tblRequest
WHERE FName Like '*' & Forms!frmSearch!txtFName & '*'
 
Do not know if this will work but try this

dim vbstring as string
vbstring = "select fname, lname from tblRequest where
fname like *" & forms!frmSearch!txtFname & "*"
docmd.runsql (vbstring)
 
WHERE FName Like "*" & Forms!frmSearch!txtFName & "*"

The form must be open when the query is opened.
 
Back
Top