Thank you much for spending your valuable time to solve my queries. Chriso you are absolutely correct. Anyway the above methods are not at all working. my access db is file ACCDB, not MDE,ACCDE. I have accomplished this issue using the Macro. Now my acccess form working as i expected. Thanks guys..