Thanks for the reply, I have never thought of using a listbox, so I am not sure if it will be easier or a nightmare to achieve what I am trying to do. maybe someone with more experience than me would be able to chip in, I have been hung with this problem for quite a while so would really appreciate everyones expertise here. Thanks for all your time.