Code for refreshing a form after updating a subform

[TheunsGoosen]

Access beginner
Hi,

I have a Command button on my form that works perfectly. It refreshes the form and all the sub-forms with the following code:

DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70

..but I need one of the sub-forms that was created from a query to refresh the form after updating one of the cells. I have tried the following and it’s not working.

Private Sub ActionCode_AfterUpdate()
DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70
End

Thanks
Theuns

 

[Remou]

You can use Requery, for example:

[tt]Me.Requery
Me.cboCombo.Requery
Me.[A Subform Control].Form.Requery[/tt]