Thanks for replying and proposing a better solution but even with form field I would be scratching my head to resolve it as I am novice in VBA and would certainly change all the fields to form field to suit what you could offer me as a soultion by giving me a macro that will do the required task.

Thanks again in advance for your help.

Chuck