Hi Plog,
Thanks for that, i haven't been able to make it as neet and i do have three or four update queries running at the same time it make it work, but it work and when put in as a VBa button its does go though quite nicely, so thank you for pointing me at that site!