CODEWITHSUNDEEP
ms-accessformsvbasubform
Justin
Justin

Reputation: 4539

MS Access 2003/2007 - Subform as control panel, closing parent form with global like reference?

I am sorry if the title is wrong, but I think that is what I mean to ask.

So I have a subform created that I would like to use, sort of like a control panel, that allows user to select a range of different forms. So the same subform ends up in a lot of different parent forms. I would like to use simple 

docmd.close acform

but i am looking for a way to reference the parent form like "active form" or something like that so I can close whatever form is open before opening the intended form. that way i can use the same sub form (control panel) in a lot of forms and it works globally??

thanks justin

Upvotes: 0

Views: 1870

Answers (1)

HansUp
HansUp

Reputation: 97101

From within the subform you can get the name of its parent form with:

Me.Parent.Name

Upvotes: 2

Related Questions