Raghu,
Glad to help, something I forgot to mention, when you open my subform you will note that some of the controls have a yellow background - these are the ones I have set to visible = no. Also have a look at the small amount of code behind the subform - all for re-query
Good luck with your...