Hi

Thanks for that, it now works. I have also changed the field name as you recommended.

Can you help with one other thing?

If the search brings up more than 1 customer with the same name the VB form will only show the first customer. In MS Access when you run the search if there is more than one customer returned you are able to scroll between records with first, next, last and add new buttons at the bottom of the form. Can this be done in VB.NET also?

Many Thanks

Darrell...