Subform Popup open issue

[GraemeG]

Hello.

I have a command button which is password protected by a custom form with a password txtbox. If the password is correct I want it to then open a form.

However the issue is - I want to open up thid form as a subform on the controlsourceobject in my main form.

Is this possible?

My main form is called: RRC MAIN
The controlsourceobject is called: subControlSource
The popuppassword form is called: FrmDataEditorLevLoginScn
The form I want to open in the object source is called: FrmAddData

Any help much appreciated

 

[missinglinq]

Rather than opening the secondary form, with the command button, I'd set the subform control's Visibility Property to False, and then use the password protected command button to change the Visibility to True.

Notice I said the subform control's Visibility, not the form the subform is based on.

Linq ;0)>

 

[GraemeG]

Rather than opening the secondary form, with the command button, I'd set the subform control's Visibility Property to False, and then use the password protected command button to change the Visibility to True.

Notice I said the subform control's Visibility, not the form the subform is based on.

Linq ;0)>

It is not a subform in control. I have got an embedded Object Source. And depending on what command is pressed the subform appears i nthe control source. I have not got all the subforms preloaded and hidden.
I want to be able to open the form within this embedded blank object source on the main form. Like I have all my other subforms under commands doing.

i.e. Commands on the main form work with: me.subSourceControl.sourceobject = "Me.Frm...." however because the password popup is another form it does not see the SubSourceControl.sourceobject.