Main form and 2 subforms

M

Makelei

Hi,
I have a main form and in it 2 sub forms. Top of the main form I have
several textboxes where I can write text or leave empty and by clicking a
button it will filter BOTH of the sub forms ok.

I have another button to clear filtering. For a reason or other it will
clear ONLY the first one in code. I need them both to be cleared. This is the
code I use:
*******************************************
Private Sub RemoveFilter_Click()
On Error GoTo Err_RemoveFilter_Click

Forms!Main.APlanQuerySbForm.Form.FilterOn = False
Forms!Main.BaselineSumQuerySbForm.Form.FilterOn = False

Exit_RemoveFilter_Click:
Exit Sub

Err_RemoveFilter_Click:
MsgBox Err.Description
Resume Exit_RemoveFilter_Click

End Sub
*******************************************
Could you please help me to find a way to clear both sub forms with one
button. Thanks in advance
MakeLei
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top