I have used similar to the following code to filter a linked form and have it update as I move through the records on a main form. The previous (working) one I had was using a text field to link the 2. I am using similar code on a form I have now, only the linking field is an integer. The form opens fine and is filtered, but when I scroll to the next record, the linked form does not update. Any suggestions?
Private Sub FilterPhoneNumEntryForm()
If Me.NewRecord Then
Forms!frmPhoneNumEntry.DataEntry = True
Forms!frmPhoneNumEntry.Filter = "CustomerIDFK = " & Me![ID]
Forms!frmPhoneNumEntry.FilterOn = True