Subform ControlSource Popup 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 this 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

[pbaldy]

Try

Me.subControlSource.SourceObject = "ThirdFormName"

[GraemeG]

Try

Me.subControlSource.SourceObject = "ThirdFormName"

That is what I am using for commands on the main form. this does not work on a pop up, as the popup is another form and does not contain the sourceobject.

[pbaldy]

I'm not clear on the setup, but to set some other form's subform this should work:

Forms!OtherFormName.subControlSource.SourceObject = "ThirdFormName"

[GraemeG]

I'm not clear on the setup, but to set some other form's subform this should work:

Forms!OtherFormName.subControlSource.SourceObject = "ThirdFormName"

 Forms!RRC_MAIN.subControlSource.SourceObject = "FrmLifeCycleCosts"

I have tried this and I get a 2450 error.
Riverside Control Centre can't find the Form 'RRC_MAIN' referred to in a Macro or Visual Basic Code

[pbaldy]

Is that form open?

[GraemeG]

Is that form open?

Yeah it is constantly open. and is open in the background when the popup password form opens.

[pbaldy]

Then the name is incorrect. Could it be a space instead of an underscore? If so you'll have to bracket the name.

[GraemeG]

Then the name is incorrect. Could it be a space instead of an underscore? If so you'll have to bracket the name.

No the form name has an underscore.
It still does not find it whether I name the form with an underscore or not.
How would I bracket the form up anyhow?

    Forms![RRC_MAIN]!subControlSource.SourceObject = "FrmLifeCycleCosts"

?? This does not work

[pbaldy]

Can you post the db?

[GraemeG]

Can you post the db?

not particulary it has got senstive data in it. Without the data it would be hard to understand.