Thanks my friend,

I am building this for a customer, lets hope that they use 2007 or 2010. By the way i just removed the part of cod which unload and show the form again after submitting first record. It works now but i need to press the button to add next record which is not too bad

I do appreciate all others if they can help.

Thanks.