I am filtering data on a form
Using the following code
Private Sub txtMember_Change()
txtMemCriteria = txtMember.Text & "*"
Me.RecordSource = "qryLHOFilter"
If Not IsNull(Me.txtMember) Then Me.txtMember.SelStart = Len(Me.txtMember)
it is working but when I enter text like x where no records start with x I am getting the following error message
Run Time Error 2185
You can't referenece a property or method for a control unless the
control has the focus.
I want it to give a message there are no records for that selection and change the text criteria back to null