Refresh Subform from Main form button

[Emma Aumack]

Hi all,

Here is my problem:

I am trying to clear the contents of a subform as follows:

Private Sub Cmd_ClPriceAprvl_Click()
On Error GoTo Err_Cmd_ClPriceAprvl_Click

Dim stDocName As String

stDocName = "Qry_MyPriceAprvl_Flush"
DoCmd.OpenQuery stDocName, acNormal, acEdit

Exit_Cmd_ClPriceAprvl_Click:
Exit Sub

Err_Cmd_ClPriceAprvl_Click:
msgbox Err.Description
Resume Exit_Cmd_ClPriceAprvl_Click

Forms!Frm_MyPriceApproval.Requery

End Sub

Frm_MyPriceApproval data is coming from a table (tbl_MyPriceApvl) where data
from another query is appended. I have tried requery and refresh and neither
works. What am I doing wrong?

Thanks

 

[Emma Aumack]

I had it in the wrong place. Thank you!!