Search results

I've tried taking out all the & symbols individually and it gives an error every time, and I meant that I thought you could just use the "Or" operator somewhere like this (this isn't right but this is what I was thinking of) Private Sub Command82_Click() Me.Filter = "TASK_NUMBER Or anotherField...

Also it would be convenient if it can search both numbers and text, not sure if that's an issue in this case...

Hey so it's literally just a command button, it's not a part of a larger code, so what I have is: Private Sub Command41_Click() Me.Filter = "ORDERNUMBER Like '" & "*" & Me.Text37 & "*'" Me.FilterOn = True Me.Requery End Sub

Just tried that, and it gives error 3464 "Data type mismatch in criteria expression, it's also not recognizing the "OR" as an operator (ie it's not turning blue)

hey so I have this code which filters a form with the command button ("Command 82"), but it only searches in the "TASK_NUMBER" field. How can I make it search multiple fields at once? I feel like you can just use the "Or" operator, but where do I put it? Private Sub Command82_Click() Me.Filter...

awesome! so it worked when I did Private Sub Command41_Click() Me.Filter = "ORDERNUMBER Like '" & "*" & Me.Text37 & "*'" Me.FilterOn = True Me.Requery End Sub Also does anyone know where I'd put the "Or" operator to make it search several fields at once?

where in the code would you put that? because i tried replacing the Me.Text37 & "'" 'with Like "*" & Text37 & "*" and it doesn't do anything different

Hey so I have a table with a field called ORDERNUMBERS, and so far I have a text box (Text37) and a command button (Commmand41) Private Sub Command41_Click() Me.Filter = "ORDERNUMBER = '" & Me.Text37 & "'" Me.FilterOn = True Me.Requery End Sub The only problem is that it searches for EXACTLY...