Hi thank you very much it works great so easy when you have experts guiding you in the right direction.

One further thing how would i make it so that the fields in a2, a3 etc appeared blank until the information was inserted in a1?

Thanks very much for all your help.