combobox autoexpand strange behavior

I have a combobox whose rowsource is: select last & ", " & first from mailingList, and autoexpand is True.
I have a person in the mailingList with last = "I" and first = "P".
When I type 'i' in the combobox I, P appears (as expected), but then the insertion point jumps to just past the I and autoexpand does not respond as expected to entry of a 2nd last name letter. Any thoughts?
LVL 17
ramromconsultant Asked:
Who is Participating?
 
puppydogbuddyConnect With a Mentor Commented:
Try using the keyword "Distinct" as discussed in this link:

         select DISTINCT last & ", " & first from mailingList

             http://support.microsoft.com/kb/824189
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.