I have an access database containg customer name, number and address.

When I enter the name PRICE, I want the code to search the database, offer me all the PRICEs so I can see if I'm entering a new customer or an existing customer. If its an existing customer I want to be able to then select that customer from the list an use the existing address and customer name to populate my new entry.

Any help out there?

Thanks

Bern