I have my code for my filter as follows:
Two things:
1. How do I get the filter to accept part names ? ie If I entered LIN then my results would be LINK, LINDY, LINNER, BLINK. Im not sure where to put the wildcard "*"
2. As you can see from my code, the set focus moves to textBox2
I would like this to be an additional filter.
Something like:
I'm sure its just a case of my coding !! Unless what Im doing is the wrong way to go about this?
Thanks you lovely people.
Code:
Private Sub textBox1_AfterUpdate()
If IsNull(Me.textBox1) Then
Me.FilterOn = False
Else
Me.Filter = "surname = """ & Me.textBox1 & """"
Me.FilterOn = True
End If
Me.textBox2.SetFocus
End Sub
Two things:
1. How do I get the filter to accept part names ? ie If I entered LIN then my results would be LINK, LINDY, LINNER, BLINK. Im not sure where to put the wildcard "*"
2. As you can see from my code, the set focus moves to textBox2
I would like this to be an additional filter.
Something like:
Code:
If IsNull(Me.textBox1) Then
Me.FilterOn = False
Else
Me.Filter = "firstname = """ & Me.textBox2 & """" & what is in textBox1
Me.FilterOn = True
End If
Me.textBox2.SetFocus
I'm sure its just a case of my coding !! Unless what Im doing is the wrong way to go about this?
Thanks you lovely people.
Last edited: