volgen :)

If you click the drop down on the combo box and both michaels show up there, that is how it's designed to search as you type, you cant have it switch to a different one unless you type enough of the name to have it realize you want the other one.

If you click the combo box dropdown and only one michael is there, and there should be 2, that means your row source has something wrong in it, or a query in the row source is limiting the results with criteria or an aggregate query

Hi Richard, a combo box only matches the starting characters of each entry with what you type into the combo box.  For instance, if a combo box contains the list of entries below, and if you type "Michael" into the combo box, only one match (Michael Chang) will be shown, because that is the only entry that begins with "Michael":

A. Michael Hall
Michael Chang
George Michael
Al Michaels

Well, the first "Michael" isn't the one I want to select.

This is the query for row source:

SELECT Contacts.ContactID, Contacts.ContactFirstName, Contacts.ContactLastName, Contacts.Email, Company.EID
FROM Company INNER JOIN Contacts ON Company.EID = Contacts.ENTContactID;

Kevin,

Your point is well taken but both first names are Michael

If the second Michael isn't in there then there's something wrong with the setup. Like the second Michael doesn't have a linking record in Company maybe.

I would suggest making a query and playing with it until you find the problem or get both michaels to showup in the query results, then go to sql view and take that and put it as your row source.

Are both of these Michaels in the same company?

When I run that query, it is a simple select statement and all records show up, including both Michaels.  How does the combo box apply the filter or criteria to acxt as a where condition?