I am new to access 2003 and have created a form for a client information db. I have created a search by last name field so that I can go directly to that clients information, but if I have a duplicate last name it will not go to the next name. Under the Row Source I have enter this code:
SELECT [Client Information].MailingListID, [Client Information].LastName FROM [Client Information];
Any help would be appreciated.