SubForm Rows Not Displaying Correctly When Directional Arrow Used.

[RitaG]

Hi.

I'm using Access 2003.
I have a SubForm within a form. When a textbox's value changes, the rows
displayed on the SubForm change. This works fine when I do a search for a
value in the textbox. However, when I use the directional arrow at the bottom
of the parent form after the form's opened to get the next row of the parent
form, the SubForm's contents are the same as the previous parent's form which
is incorrect.

I tried applying my filter on different events, finally discovered that the
only events fired up in this situation are the SubForm's ApplyFilter and
Current events.

Here's the code I used in the ApplyFilter event:
Me.FilterOn = True
If Not IsNull(Me.Parent!txtSCRID) Then
Me.Filter = "LinkedSCRorDefect <> " & Me.Parent!txtSCRID
End If
Me.Requery

I'm still not able to get the desired results using this method.

Any suggestions will be greatly appreciated.
Thanks.

Rita