Requery a subform from another form (1 Viewer)

[brainox]

I have a subform in a tab within a mainform. Within the tab there is a button to open a form to delete/add data to the subform. So upon closing this pop up form I want to update the subform to show what has been deleted or added, I have tried the various things to requery the subform but none of it seems to work, here is what I have tried;

Forms!frm_Capex_Submission!frm_CapexSignatures.Requery

I assumed this would work but evidently not...

I have also tried;

Forms!frm_Capex_Submission!frm_CapexSignatures.Form.Requery

and;

Forms!frm_Capex_Submission!frm_CapexSignatures.refresh

Many thanks

 

[Lojita]

you have to force the data to be saved.
try this.

IF Me.Dirty Then Me.Dirty = False
Forms![frm_Capex_Submission].[frm_CapexSignatures].Form.Requery

This way should work

 

[brainox]

you have to force the data to be saved.
try this.

IF Me.Dirty Then Me.Dirty = False
Forms![frm_Capex_Submission].[frm_CapexSignatures].Form.Requery

This way should work

Thank you for your help but it still isn't working