I have a form that is based on a query. I what to lookup an existing record so i used the lookup tool in the toolbox. The problem is that if i have more than one person with the same last name it only goes to the first one, no matter which person i select from the list. I know what the problem is but i dont know how to fix it. The primary key is an autonumber say PersonID, and then i have First Name and Last name.
If i put only the First and Last name in the Lookup combo box i get the problem.
If i create another combo box and include the primary key and the First and Last name then the problem goes away, BUT now i cannot type in a last name and have the combo box jump to that name. Now i have to go throw the whole list to find the person i am looking for and this takes too much time. I know why this happens i need to lookup by the primary key but when i am doing the search i don't have that information.
Please, is there an easier way to do this???

Thanks for any help

I figure this one out. All i needed to do was change the order of the columns so that Last Name is first, then i can type in a last name and it will look for that record.
Live and learn!!!