Access - Difference between Refresh and Requery
Posted on 2007-10-09
Please explain the difference between refresh and requery. My application is focused on having the user select a value from a combo box. That value is transfered between several forms using OpenArgs. Which one, refresh or requery, should I use for the following and where should it be placed?
-The combo box OpenArg opens up a form that allows the user to add a new record directly from a form. Do I need to refresh or requery the table and the combo box? Where should my refresh/requery be placed in the code?
- The combo box OpenArg opens up a form and a subform that allows the user to add a new record. Do I need to refresh the Main and subform? Where should the refresh/requery be placed in the code?
- What other suggestions do you have as far as placing a refresh or requery throughout the application?