search form with three text box option not working

[raton]

i have search form with a subform. Subform based on a query.
there are 3 text boxes. with three different criteria for search
example. search by name, search by date, serch by number
three radio button which is used to highlight one search text box at a time
problem
write name in name txt box click search button requery subform
but when i click another radio button to highlight another txt box
the subform is not being clean. it contain the prior result
but i want to clean the subform everytime i select the radio button.

[June7]

You need to unfilter the subform before applying new filter.

Show code you have or provide project for analysis.

[raton]

form is serached by query
query1
field, name, number, id,
criteria Forms!frmname!textbox1
or Forms!frmname!textbox2
or Forms!frmname!textbox3

three radio button in a option group code

Me.text1.Visible = True
Me.text2.Visible = False
Me.text3.Visible = False
Me.Qservice_subform.Requery
End Sub












Private Sub mnumber_GotFocus()
Me.text1.Visible = False
Me.text3.Visible = False
Me.text2.Visible = True
Me.Qservice_subform.Requery
End Sub






Private Sub rdate1_GotFocus()


Me.text1.Visible = False
Me.text3.Visible = True
Me.text2.Visible = False
Me.Qservice_subform.Requery
End Sub

private sub cmd1_click()

Me.Qservice_subform.Requery
end sub

[June7]

That didn't help. I don't understand what radio buttons have to do with the search textboxes. Appears I will have to see the project.

[raton]

i want to make a search form
a text box will be there. and a cmd button
i want to retrieve query result
the query has 5 field ( field1, field2,field3,field4,field5,)
i want the search by field1, or field2, or field3,
as the textbox is only one, i have used 3 radio button
to choose that now the search will be happened depending on the field1 of the query
(radio button is used to choose on which field the search will happen)
how can i do that pls show me thw way..................

[June7]

As far as I can tell, none of the code you show does anything to alter the search parameters. Also, the controls referenced in the query statement are not the same names as you show in the VBA code. If you are showing alias information and not your actual code, that just confuses. Show your real code. Review this tutorial about filter criteria in queries http://datapigtechnologies.com/flash...tomfilter.html

Possibly what you need is wildcard in your filter criteria as demonstrated by the tutorial.