Hi Everyone,
I need to have a small form load at startup containing a text box (user types in Last Name) A list box that starts being filtered by the characters the user types in the text box and allow a value in the list box to be double clicked and the main information form opens up with the complete information to be edited or viewed. Backend is SQL 7 Frontend is Access 97. Any Ideas? Thanks V/R Del Hundley

Use a combo box as it will start filling in the data as you type and will not let the user select data that does not exist. In the after update event put your code to open the form you want.