Thanks for the reply Saalim.
I tried using the executequery method on the forms datasource but it was still not working. It works if you open a form from a menu item but through tab switch, not working. If possible, could you provide a sample or example on how could we create a custom refresh mechanism or any other way? Also the form only has activate method, but datasoirce does have active method, should I use that one?