Apr 18 2007, 06:46 PM
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.
Apr 18 2007, 08:18 PM
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.
Apr 18 2007, 08:43 PM
Welcome to UA!!
In addition to Balaji's post, you could try:
Good luck with your project.
Apr 19 2007, 01:54 AM
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.
Apr 20 2007, 10:29 AM
Thanks everyone. I used Aqua's suggestion-seemed the easiest and it worked.
Thanks for all of your help!!!! -o!
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here