Me.Requery

There's a button you can click to convert macros to VBA.

Kevin Where would you put the me.requery code at?

Richard, you put it in the event that you needed to update all the records in your continuous form or a list box. in other words, it depends on what changes have you made and where and then you trigger it from there

Commonly done in an after update on a field you just changed

I am following the lesson mentioned above, so I am making changes in the orderF and want the reflected in the orderlistF without having to click on the command button.

Add this code to the Close event of the OrderF:

Private Sub Form_Close()

    If CurrentProject.AllForms("OrderListF").IsLoaded Then
        Forms!OrderListF.Requery
    End If
    
End Sub

This will Requery the Order List whenever the Order Form is closed.
It also makes sure OrderListF is loaded so you don't get an error if it is not open.

Thanks this is just what I need!

Can this code be duplicated in the same Close event only with another Form?
Such as Private Sub Form_Close()

    If CurrentProject.AllForms("OutstandingInvoiceListF").IsLoaded Then
        Forms!OutstandingInvoiceListF.Requery
    End If
    
End Sub

Try it Yourself