You could use an InputBox to provide the prompt, but why make your user remember the Surname they want to see? Why not provide a combo box on the form with all the Surnames. The user can scroll thru the list, click on the desired Surname, and you can use the combobox_click event to do your lookup.