Let me see if I understand:
You have 3 unbound text boxes on a bound form:
txtCounter1 (this shows the current record you are on)
Control Source (=[Form].[CurrentRecord])
txtCounter2 (this shows the total number of records in the form record source)
Control Source (=Count([ID]))
txtJumpSearch (unbound textbox to enter the number you want to go to)
There is a button named "cmdJumpSearch" with code
Code:
Private Sub cmdJumpSearch_Click()
Me.Filter = "[id]=" & Me.txtCounter2 & Me.txtJumpSearch
Me.FilterOn = True
End Sub
So if Me.txtCounter2 = 100 (total number of records) and you want to go to record 44 (Me.txtJumpSearch), then
Me.Filter = "[id]=" & Me.txtCounter2 & Me.txtJumpSearch
that means
Me.Filter = "[id]=" & 20044 ' (200 & 44) = 20044
You want to go to record #20044 ????? It is greater than the total number of records.
Why aren't you using
Code:
Private Sub cmdJumpSearch_Click()
Me.Filter = "[id]=" & Me.txtJumpSearch
Me.FilterOn = True
End Sub