Closing Form from Subform

[cjmitton]

In my Main form (frm_Matters) I have a subform (frm_Others) in that form I have a button which opens a new pop up form (frm_Other_Business) but I then need to close the form that it came from (I.e the Parent form 'Matters').

I've used the code I usually use when opening / closing forms but as I'm running this from a subform (I'm guessing) its trying to close the subform instead of the parent so I tried the following but still not luck.

DoCmd.Close acForm, Form!frm_Matters, acSaveNo

Any thoughts please?

 

[vbaInet]

Something like:

DoCmd.OpenForm "FormName"... etc
DoCmd.Close acForm [COLOR=red]Me.Parent.Name[/COLOR], acSaveNo

Leave the bit in red as it is.

 

[cjmitton]

Excellent, thanks for that. I thought I would have to be more specific!

 

[vbaInet]

You're welcome!

Na, as long as you call the parent form it will be fine.