Using a form field and wild cards in a query

[billkeziah]

I am creating a search form with a text box called text0.

I want to run a query using the asterisk before and after the value of the text box.

I have tried the following:

SELECT * FROM casenumbers WHERE [keyword1] Like [Text0]
SELECT * FROM casenumbers WHERE [keyword1] Like '*[Text0]*'
SELECT * FROM casenumbers WHERE [keyword1] Like '[*Text0*]'
SELECT * FROM casenumbers WHERE [keyword1] Like *[Text0]*
SELECT * FROM casenumbers WHERE [keyword1] Like %[Text0]%
SELECT * FROM casenumbers WHERE [keyword1] Like '%[Text0]%'
SELECT * FROM casenumbers WHERE [keyword1] Like '[%Text0%]'

Nothing seems to work, Please help!

 

[chrissie1]

SELECT * FROM casenumbers WHERE [keyword1] like '*' & forms!Form1.form.text0 & '*';

i expect a thank you for this
Christiaan Baes
Belgium
"What a wonderfull world" - Louis armstrong

 

[billkeziah]

THNK YOU!!!!!