Refresh subform from separate form

[Perineum]

Any help would be greatly appreciated. I have a form called frm_Incident_Single. On this form I have a subform/subreport called tbl_Incident_Apps_subform. I have a command button on frm_Incident_Single that opens another form called frm_Incident_Apps where I choose multiple selections. When I save or close the form I would like to update the subform - tbl_Incident_Apps_subform.

I've tried to requery/refresh the subform in the save procedures in frm_Incident_Apps but when I save it, I get a syntax error. Here is the line of code:

Forms!frm_Incident_Single!tbl_Incident_Apps_subfor m.Form!Requery



I've tried many variations and can't get it to work. Could someone please advise me on how I can refresh the subform?

thanks
Sean

[msoffice.vidyarthi]

what does the syntax error say, attaching the sample db would help to analyze

try tbl_Incident_Apps_subform.form.requery OR tbl_Incident_Apps_subform.requery in unload sub of frm_Incident_Apps

[Perineum]

Thanks for your reply. The error I get for my code is "Compile Error: Syntax error". Unfortunately, my work will not allow me to upload the db.

I tried your code in the unload event of frm_Incident_Apps and for both variations, I get the error:

"Run-time error '424': Object required"

[Perineum]

I didn't know that a frickin' command button would do this. Stumbled on it accidentally. Easy as pie. Case closed.