How to refresh FormA subform ?

[cheer]

How to refresh FormA's subform data when the FormB unload events is fired ? My current code in FormB is below

Form B
Private Sub Form_Unload(Cancel As Integer)
Forms!frmA!SubFormA.Requery=> Error: Method 'Items' of object Forms 'failed'
End Sub

 

[John Big Booty]

Check this link for the correct syntax for referring to subforms and thier properties.

Try;

Forms!frmA!SubFormA.Form.Requery

 

[cheer]

Check this link for the correct syntax for referring to subforms and thier properties.

Try;

Forms!frmA!SubFormA.Form.Requery

same error as above

 

[John Big Booty]

Sorry missed this link in my previous post.