I have a textbox on my form and a sub bound to its change event, whenever someone is typing into the textbox i want to dynamically filter the results as they type. Right now each time i type a character it either highlights the entire textbox thus erasing what you already typed, or the focus jumps down to a field in the data area, is there anyway to prevent this?
Code:
Private Sub Term1_Change()
If IsNull(Me.ActiveControl) Then
Me.FilterOn = False
Else
Me.Filter = "Tag = """ & Me.ActiveControl & """"
Me.FilterOn = True
End If
End Sub