If anyone has a VB program to code a command button to look-up Customers' surname from a table from entry of text box eg "Smit*" , I will be eternally grateful.......
Do you want an auto fill-in as the user types? If so just set the textbox's source as a query to the table and on the textbox's keypress requery the textbox.
