query about search button in my form

[neelesh kumar]

sir,
i have a form exam created by using a table tblexam.In the tblexam fields are questionno,ques tion,option1,op tion2,option3,o ption4,answer fields.
In my form i have a question,option 1,option2,optio n3,option4 textboxes having control sources from tblexam .Along with search command button and 1 unbound text box named text20.
If i enter some word in that text box and then click search then i want to get all the records matching that word in the table in the form.
If Me!Text20.Value <> "" Then
Dim dbss As DAO.Database
Dim rsts As DAO.Recordset
Set dbss = CurrentDb
SrcSQL3 = "SELECT tblexam.* FROM tblexam WHERE like tblexam.* like text20& " * ""
Set rsts = CurrentDb.OpenR ecordset(SrcSQL 3, dbOpenSnapshot)
If rsts.BOF And rsts.EOF Then
MsgBox "Questions not found , Please Try Again."
Else
questionno.setf ocus
DoCmd.ApplyFilt er SrcSQL3
rsts.Close
dbss.Close
End If

my problem is with SrcSQL3 select query statement.
please help me.
how to write the query

[Rabbit]

A filter is only the WHERE clause of the SQL statement, without the word WHERE.

[neelesh kumar]

i want to get all the records matching the text typed in the textbox named text20(say) from the table tblexam.
docmd.applyfilt er SELECT tblexam.* FROM tblexam WHERE
please tell the WHERE condition
thanks in advance

[Rabbit]

From the help files:

The ApplyFilter method carries out the ApplyFilter action in Visual Basic.

expression.Appl yFilter(FilterN ame, WhereCondition)

expression Required. An expression that returns one of the objects in the Applies To list.

FilterName Optional Variant. A string expression that's the valid name of a filter or query in the current database. When using this method to apply a server filter, the FilterName argument must be blank.

WhereCondition Optional Variant. A string expression that's a valid SQL WHERE clause without the word WHERE.

[neelesh kumar]

want to get all the records matching the text typed in the textbox named text20(say) from the table tblexam.
docmd.applyfilt er "SELECT tblexam.* FROM tblexam WHERE tblexam.questio n like ' "Forms!frmsetqu estions!text20 " ' "
with the above query i am not geting the required records.
suppose if the question is "what is speed" then in the textbox if i type speed i am not getting that question.If i give full question only in the textbox i am getting that record.
but i would like to give only some word in the question,i have to get the record.
please tell the WHERE condition how i have to modify
thanks in advance

[Rabbit]

You're looking for wildcard characters.

From the help files:

? or _ (underscore) = Any single character
* or % = Zero or more characters
# = Any single digit (0— 9)
[charlist] = Any single character in charlist
[!charlist] = Any single character not in charlist