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
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