Need help changing a "filter" button to a "go-to" button

[templeowls]

I have a form that looks at a bunch of customer complaints one at a time. I've got a button that allows the user to input a 'ComplaintNumber' so that they can go right to a certain complaint if needed. The issue is that it filters down to just that complaint. It'd be more useful if it only went to that complaint without filtering away the rest. I looked online for a solution but the only guides I could find were ones that filter. If anyone has any guidance or guides, that'd be awesome. Below is the code for the button that I'm currently using.

Private Sub btnSearchComplaintNumber_Click()    
    Dim S As String
    
    S = InputBox("Enter the Complaint Number", "Complaint Number Search")
    If S = "" Then Exit Sub
    
    Me.Filter = "ComplaintNumber = " & S
    Me.FilterOn = True
    
End Sub

[Welshgasman]

Posted in error

[Minty]

Use a bookmark on the current forms recordset.

An example you can adapt is here https://docs.microsoft.com/en-us/off....form.bookmark

[Micron]

Probably could move to the desired record with just 2 lines:

Me.recordsetclone.findfirst "ComplaintNumber = " & S
Me.bookmark = Me.recordsetclone.bookmark

I'm surprised that the posted filter code works because S is a string and in the criteria, it's not delimited at all. Would have expected you'd need
"ComplaintNumber = '" & S & "'"

[templeowls]

Probably could move to the desired record with just 2 lines:

Me.recordsetclone.findfirst "ComplaintNumber = " & S
Me.bookmark = Me.recordsetclone.bookmark

That worked!! Thank you!!

I'm surprised that the posted filter code works because S is a string and in the criteria, it's not delimited at all. Would have expected you'd need
"ComplaintNumber = '" & S & "'"

I tried that originally but it didn't work because the field is a number field.

[Micron]

I tried that originally but it didn't work because the field is a number field.

Then you should not declare S as a string. Instead, use Integer, or probably better, Long.

[moke123]

I'm not a big fan of input boxes and usually avoid them as I always think they leave too much room for error. I dont know how many complaints you have or how complicated the complaint number may be.
Normally I'd have a combobox on the form to jump to a record. It has the advantage of ensuring a correct number is entered and it will find as you type.

That said, there was a recent thread about TaskBoxes and I've been trying to utilize them as a learning exercise.

Here's a Taskbox procedure that uses a find first routine.