What is the difference between requery and refresh

For a more specific or a thorough update, use a macro to requery the data. Note: Running the requery process can be time consuming depending on the size of the recordset. Refresh data. Set the refresh interval. Use a macro to requery data. Use code to requery data. Requery data in an Access web app. You can set the interval at which Access refreshes data. By default, Access refreshes data every 60 seconds. In the left pane of Access Options dialog box, click Advanced. In the right pane, under Advanced , specify a value for Refresh interval sec.

If you want data to be requeried automatically when an event occurs, you can create a macro and attach it to the event. For example, suppose that you want to requery the data in a form whenever the form receives the focus. You could create a macro and attach it to the form's On Got Focus event, by using the following procedure:. On the Create tab, in the Other group, click Macro. If this command is unavailable, click the arrow beneath either the Module or the Class Module button, and then click Macro.

Save the macro, using the name Requery , and then close the Macro Builder. Join Us Close. Join Tek-Tips Forums! Join Us! By joining you are opting in to receive e-mail. Promoting, selling, recruiting, coursework and thesis posting is forbidden. Students Click Here. I use Refresh alot, but while reviewing something in help I came across Requery again and Recalc. What does Requery do differently than Refresh? I just read Requery does not reset the record pointer a problem I have been fixing on a lot of forms.

What is the downside? And also where does Recalc come into play? Is that just when your records from the query are the same but the data has changed?

If anyone can clearify I would appreciate. Thanks, However, I read it an it does not make sense because of what I am doing.

I have a screen which basically runs off a timer interval, refreshing every 15 seconds. Any new records updated by another department changing the status will appear on this form when I do a refresh.

Search titles only. Search Advanced search…. New posts. Search forums. Log in. Install the app. For a better experience, please enable JavaScript in your browser before proceeding. You are using an out of date browser. It may not display this or other websites correctly. You should upgrade or use an alternative browser.

Difference between Requery and Refresh method. Thread starter Don Start date Jul 10, I'm using a access 97 application. What's the difference between using the Requery or Refresh method of the form. Thanks Don. Albert D. Requery causes the whole reocrdset for the form to be re-loaded.

This also means that all bookmarks, and even your current position is lost.