Searching on list box Runtime Error 2110

[foxtet]

OS is Windows 7
Access Version is Ms access 2010


I have text box to search list of entries in the list box. when i type letter "i" it displays error msg as follows

Run-time error 2110

Microsoft Access can't move the focus to the control SearchResults..

the code attached to text box SearchFor is given bellow.

can I overcome this error...any help is aapricaited
Fox


Private Sub SearchFor_Change()

'Create a string (text) variable
Dim vSearchString As String

'Populate the string variable with the text entered in the Text Box SearchFor
vSearchString = SearchFor.Text

'Pass the value contained in the string variable to the hidden text box SrchText,
'that is used as the sear4ch criteria for the Query QRY_SearchAll
SrchText.Value = vSearchString

'Requery the List Box to show the latest results for the text entered in Text Box SearchFor
Me.SearchResults.Requery


'Tests for a trailing space and exits the sub routine at this point
'so as to preserve the trailing space, which would be lost if focus was shifted from Text Box SearchFor
If Len(Me.SrchText) <> 0 And InStr(Len(SrchText), SrchText, " ", vbTextCompare) Then
Exit Sub
End If

'Set the focus on the first item in the list box
Me.SearchResults = Me.SearchResults.ItemData(1)
Me.SearchResults.SetFocus

'Requery the form to refresh the content of any unbound text box that might be feeding off the record source of the List Box
DoCmd.Requery

'Returns the cursor to the the end of the text in Text Box SearchFor
Me.SearchFor.SetFocus

If Not IsNull(Len(Me.SearchFor)) Then
Me.SearchFor.SelStart = Len(Me.SearchFor)
End If

End Sub

 

[saladin]

foxtet i had the same issue but the solution is rather simple but weird.

Just disable auto correct from automatically changing common i to capital.

This really worked.

 

[foxtet]

Hi
saladin,

Thank you so much for the help..

fox