<div>
You refresh individual objects in Access. You can refresh a Form like this:<br />
<br />
Me.Refresh<br />
<br />
Assuming you run that code directly in the form's Code module. You can also refresh a form like this:<br />
<br />
Forms(&quot;YourFormName&quot;).Refr<wbr />esh<br />
<br />
Note that &quot;Refresh&quot; is different than &quot;Requery&quot;. Requery will entirely rebuild the form's underlying dataset; refresh does NOT, and is therefore used when you are certain that you do NOT need to re-fetch the dataset, but merely to rebuild what you currently have.
</div>


You refresh individual objects in Access. You can refresh a Form like this:

Me.Refresh

Assuming you run that code directly in the form's Code module. You can also refresh a form like this:

Forms("YourFormName").Refresh

Note that "Refresh" is different than "Requery". Requery will entirely rebuild the form's underlying dataset; refresh does NOT, and is therefore used when you are certain that you do NOT need to re-fetch the dataset, but merely to rebuild what you currently have.

<div>
Basically after i run my code to capture data from Outlook into my access table &quot;MData&quot;. &nbsp;I have to manually refresh the table see number of records.
</div>


Basically after i run my code to capture data from Outlook into my access table "MData".  I have to manually refresh the table see number of records.

<div>
<div class="content wysiwyg-content">
Hi Team,<br />
<br />
I know how to refresh in MS Excel VBA, but not sure what is the code for refresh all in MS Access.<br />

</div>
</div>


Hi Team,

I know how to refresh in MS Excel VBA, but not sure what is the code for refresh all in MS Access.


How to do Refresh All in MS Access VBA

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.