Filtering....I think.

[Trini Gal]

Hello,

I was wondering, is it possible to filter a form and a subform from another
form?

I have a form (frmAdd_Leak), that has a subform (frmAdd_Leak_Subform), they
are attached by txtCommunity. I have another form (frmEdit) that is attached
to the subform by txtLeakID.

When the user wants to edit existing data, they click on the Edit button,
and the frmEdit open where they enter their name and todays date. I want
when they click the okay button, that second form closes and then frmAdd_Leak
is filtered to the txtcommunity, and the frmAdd_Leak_Subform is filtered to
the txtLeakID.

Is this possible?

Someone told me I need to set the forms!Formname.Filter="Query String" and
then
forms!formname.Filteron=true

But unfortnately, I am new to this stuff and doesn't know exactly what they
mean or how to go about doing this. Can someone help me please.

Thanks in advance.