I am currently working on a project where I am building from ground up, I am working on a form based on a table where the customerid is stored as a field, but nothing else about the customer is in that table. The Form has a combo-box that allows the user to choice customerid. (I have the names populate to 2 unbound textboxes based off this). What I am trying to work out is a script using the keypress event in the last name textbox that will conduct search and auto-fill. at first seemed easy enough but when i started to actually think it though just cant get my mind around it.

Any pointers/suggestions would be helpful.

Thanks

Use a combo box.

mmcdonal