I have created a search box on my form to look at one field (Job Number) my code is below but it doesn work :S
Private Sub Filter_Click()
Me.Filter = "Job_Number = " & Me.srchbx
FilterOn = True
Me.Requery
End Sub
Anyone have any ideas? Nothing happens when I press the button and have entered criteria in te box.
Private Sub Filter_Click()
Me.Filter = "Job_Number = " & Me.srchbx
FilterOn = True
Me.Requery
End Sub
Anyone have any ideas? Nothing happens when I press the button and have entered criteria in te box.