FilterOn = False

[ybg1]

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

[boblarson]

Turning FilterOn to False isn't going to keep just the 3 records. It is jumping because you are filtering in the main form's On Currentevent. Why do you need to do that? What is the connection between the main form and the subform. It should be set up so that you just navigate to a record on the main form and then it would automatically filter the subform to fit whatever the master/child links were set. So, if those fields you are filtering the subform by are not in the main form's record source, I would be trying to figure out why as it would appear that you wouldn't have the table structure set correctly (potentially).