making a filter and search a feild

[ms shakeel]

hello sir,

thanks in advance for help

sir you know that there is "Apply Filter" Button present
in access2000.

sir i want to create my own "Apply Filter" button through
VBA.

i have used ----Forms![Transport Streams].FilterOn = True--
- in the onclick property of a command button but when i
open the form and hit "Filter By form" button the command
button gets automatically disabled. As a result of which i
cant click the command to apply the filter action.

sir plz tell me how do i do it.

also sir i have in my form "form1" there is the "Name"
box, and the name feild has the name of the record
as "abcd.trp" , "xyz.tes".
i am filtering this form based on number of values in the
combo boxes. Sir i want one of the criteria to be the
filtering operation returns those records which have an
extension as ".trp" , ".tes" etc and also should return
the filtered records when i write the complete name feild
that is "abcd.trp" or "xyz.tes" etc.

plz tell me sir how do i achieve these

thank you
shakeel
(e-mail address removed)