I have a database with a form which has a section to filter records for a list box. One of the text boxes (txt1) filters on names. txt2 filters on a date.
When a letter is entered in txt1 it triggers a change event which runs a PopulateListBox routine to populate the filtered list box with those records that have that letter in them (like '*[letter]*')
Then the code moves to the next line which checks the txt2 box for any filter entry there. The sequence moves as follows: txt2.setfocus; txt1.lostfocus; txt2.gotfocus; subroutine to populate list box
When the first letter entered in txt1 is an 'i' the sequence moves as follows: txt2.setfocus; txt1.change; subroutine to populate list box (i.e. in a circular motion) and creates an error
When any other letter is entered as the first character in the txt1 box, all works correctly, even if the first letter is a capital "I". And an "i" as a subsequent letter (after the first) does not cause a problem. It is only when the first letter in txt1 is a lower case "i".
Any light anyone can shed on this phenomenon?