forms

[mk sabeel]

hello sir,

i have somehow been able to filter records using the
advanced filter technique. what i do is

i have a form, which has a subform1,which again has a
subform2. i first define by using advanced filter
design ,what feilds i want the filter to respond to (which
would display records of those respective feilds, i have
added using advanced filter).
i then click "select by form" button , then i scroll down
different feilds in the combo box type feilds of the form
(the feilds which ared dragged while working
with "advanced filter button".
i then click "apply filter" button and then i view the
forms that respond to the feilds i have choosen, by using
advanced filter . then finally i click "apply filter"
button to stop filtering.
what i am not able to achieve is that, when i choose a
feild from the subform to veiw my the records respective
to the feild in the subform only, it is not happening.
In the advanced filter option itself i cannot get the table
(from which i can drag feilds in advanced filter option)
which responds to the subform
please help me

also is their a way that i can refresh the form to a
default values so that when a user selects feilds on the
form ,after clicking "select by form" button he should not
see the feild values from the previous filtered values in
the feilds of the form.

what do i do, please help me

waiting for a stimualting response
thank you
sabeel
(e-mail address removed)
..