<div>
On after update event??????????
</div>


<div>
Or do you mean like this<br />
<br />
Private Sub Refresh_Click()<br />
DoCmd.Save<br />
Me.yourSubFormConyrol.Form<wbr />.Requery<br />
End Sub
</div>


Or do you mean like this

Private Sub Refresh_Click()
DoCmd.Save
Me.yourSubFormConyrol.Form.Requery
End Sub

<div>
Hi,<br />
You need to select my comment and then click on the submit. That's the way we close the questions.
</div>


Hi,
You need to select my comment and then click on the submit. That's the way we close the questions.

<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
Kindly advise whether the code below can refresh the sub form properly:<br />
<br />
Private Sub Refresh_Click()<br />
DoCmd.Save<br />
DoCmd.Close<br />
Docmd.Opern Form &quot;&nbsp;Accounts&quot;<br />
End Sub<br />
<br />
I have tried the Me.Requery nothing seams working up<br />
<br />
Regards<br />
<br />
Chris
</div>
</div>


Hi

Kindly advise whether the code below can refresh the sub form properly:

Private Sub Refresh_Click()
DoCmd.Save
DoCmd.Close
Docmd.Opern Form " Accounts"
End Sub

I have tried the Me.Requery nothing seams working up

Regards

Chris

Refreshing A subform

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.