Use a inputbox to search and filter a numeric field?

[templeowls]

I've got a DB of complaints and a form that looks at each complaint one by one. I'd like to include a button next to the ComplaintNumber of each complaint that allows the user to search for a specific complaint number if they wanted to.

I found this great tutorial online that I used to allow the user to search the customer last name field, but it doesn't work for numeric fields and my ComplaintNumber field is a number field. I'm not sure what needs to be changed and I can't find any other tutorials. Any idea what needs to be altered? Here's my code:

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

[isladogs]

For a number field use

Private Sub btnSearchComplaintNumber_Click()        

    Dim S As Long
    
    S = InputBox("Enter the ComplaintNumber", "ComplaintNumber Search")
    If IsNull(S) Then Exit Sub

    Me.Filter = "CustomerID = " & S
    Me.FilterOn=True

 End Sub

[Micron]

a form that looks at each complaint one by one. I'd like to include a button next to the ComplaintNumber

Then why do you use an InputBox to get the complaint number if it's right there on the form?

Posted code will filter that form to a complaint number, but is that what you really want as opposed to navigating to that record? Also, once applied, do you have code to undo the filter so that you can get the other records back? Consider double click event for the complaint number control. One dbl click to apply filter, another to remove it.

[templeowls]

Then why do you use an InputBox to get the complaint number if it's right there on the form?

Posted code will filter that form to a complaint number, but is that what you really want as opposed to navigating to that record? Also, once applied, do you have code to undo the filter so that you can get the other records back? Consider double click event for the complaint number control. One dbl click to apply filter, another to remove it.

Yes I do have a code for a button that removes the filter. But you bring up a good point. It may be better for the user if it just "goes to" the complaint number rather than filtering down to just that complaint number. Admittedly I have no idea how to do that lol. Do you know of any guides? I did a quick search but couldn't find any.

[kd2017]

I like to use a variation of David W Fenton's code here
https://stackoverflow.com/questions/...obox-in-access

You'll need to tweak to suite your needs but the concept is there.

[Micron]

I would use the same approach as per kd107's link.