Search results

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...

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...