Solved Close a subform without closing the parent Form (1 Viewer)

[yamus]

Hello
I have 2 forms: frmA and frmB.
frmB is a subForm of frmB
frmB has a close button. I used the DoCmd.close command attempting to close frmB but what happens is that frmA also closes.
What can I do to prevent frmA from closing? In other words, I want to close only frmB

 

[theDBguy]

Can you show us your code?

 

[MajP]

If it is a subform you can set the subform control to Visible = false. Or you can set the source object to ""

 

[yamus]

Hello
I have 2 forms: frmA and frmB.
frmB is a subForm of frmB
frmB has a close button. I used the DoCmd.close command attempting to close frmB but what happens is that frmA also closes.
What can I do to prevent frmA from closing? In other words, I want to close only frmB

Hi
I attached to images
1- The parent formA within which is frmB
2- The code in the "close button" event
As you can see, I only used DoCmd.close command

 

[MajP]

You should never use close without explicitly stating what to close. You can get inadvertent results. The code should always be
docmd.close ACFORM, Me.name
This ensures you are closing the thing you want.

 

[Isaac]

Why would you want to close a subform without closing the main form? The subform is embedded in the other form.
That's like saying I want to cut down this tree--but only the "middle" of it, I'd like the rest of the trunk on bottom and top to keep standing.

 

[MajP]

AFAIK, there is no way to "close" as form instantiated as a subform. If you want to make it look like it closes see my original response and two examples. Wiping out the sourceobject will leave the subform control still visible. Or you can hide it.

 

[yamus]

AFAIK, there is no way to "close" as form instantiated as a subform. If you want to make it look like it closes see my original response and two examples. Wiping out the sourceobject will leave the subform control still visible. Or you can hide it.

Hi
It is exactly as you mentionned. After few searches online, I came across the idea of hiding subforms as if they are being closed.
I disabled the focus on the subform by setting the focus on another contol from the parent form and then I set the visibilty of the subform to none
Thank you anywaty for the help

 

[yamus]

Hi
Thank you everybody. I think I found a solution.
1- Disable the focus on the subform by setting focus on another control from the parent form
2- Set the visibility of the subform to false
Once again, I appreciate your help