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.