Hello,
I have a main form with a continuous subform. I am filtering the subform
by using the following code from the main form and it works fine.
Private Sub Form_Current()
strWhere = "[Seder_Code]=" & G_Seder & " AND " & "[Bahoor_Code]=" & G_NameCode
Me.SubFormFines.Form.Filter = strWhere
Me.SubFormFines.Form.FilterOn = True
End Sub
The problem starts when I try to enter details on the continuous subform.
For example when I have filtered 3 records and I want to amend the third record the cursor jumps to the first line.
I've realized that it happens because the subform is still on FilterOn = True
I would like to turn off the filter and to be able to change the details on the subform and still having only the 3 records that have been filtered before.
Where can I switch off the filter and how?
Thanks
FilterOn = False
