I have a form with several pages on it and those pages contain subforms/forms. I would like the entire form and the pages to update when I click a button/tab.

I have tried a refresh button/tab
I have tried a requery button/tab

I am trying to avoid putting a refresh button on every page.

Can anyone help please.

Thanks,
Angel

If there are multiple subforms on the form, you have to requery the form and then the individual subforms separately. You don't need separate refresh buttons on each page, but you do need separate refresh commands for each of the subforms fired from the same refresh button.

Angel,

Welcome to UA!!

In addition to Balaji's post, you could try:

DoCmd.RunCommand acCmdRefreshPage

Good luck with your project. (IMG:http://www.utteraccess.com/forum/style_emoticons/default/sad.gif)

Aqua

Check the help for more info on Refresh and Requery methods.

The Refresh is used to see changes to the existing set of records but will not see any additions or deletions.

The Requery will do a complete requery of the data and thus will see changes, adds and deletes.

Thanks everyone. I used Aqua's suggestion-seemed the easiest and it worked.

Thanks for all of your help!!!! -o!