I am having difficulty filtering a form as the user types in a onchange
event
here is my code
strFilter = cboCriteria.Value & " LIKE '" & Me!txtCriteria.text
& "*" & "'"
If Len(strFilter ) 0 Then
Me.FilterOn = True
Me.Filter = strFilter
Me!txtCriteria.SelStart = Len(Me!txtCriteria.text)
' End If
My problem occurs when the filter produces no results
The line
Me!txtCriteria.SelStart = Len(Me!txtCriteria.text)
gives me an error in the likes of: Cannot reference a control which
does not have the focus
can anybody help me
thanks