thanks for your feed back jeff, since i already implemented the first solution provided when i received the code in my project just wanted to change that rather then new code due to shortage of time and deadlines, later on i decided to use your solution and worked perfectly.

i will take your suggestion on

Make your code bullet proof and scalable and just assume that it will happen when you can least afford it to.

And I'd stop recaclulating things that won't change over and over again.

thanks for your continuous support to community members.