Hello all!
I have been trying to create a search bar for my form that will return the correct value if true or "no results found" if false. I have tried many different ways to do this search bar, but have been having issues with it either not producing the error message for not found or pulling up a different value entirely. See screen shot attached for more details on how I have this set up. This is still a very early work in progress, but I wanted to get this search function working before cleaning up the layout. If anyone has any pointers on the layout feel free, but my main concern is the search function. My last attempt, which is shown, was to utilize a combo box for this. I have the VBA code I found online and tried to replicate below as well for it. I appreciate any assistance on this one and look forward to communicating with everyone here.
Private Sub cboEquipmentSearch_AfterUpdate()
If Not IsNull([cboEquipmentSearch]) Then
Me.Filter = "Equipment # = '" & Me.cboEquipmentSearch & "'"
Me.FilterOn = Not IsNull(Me.cboEquipmentSearch)
Else
Me.FilterOn = False
End If
End Sub