How to reference controls on sub forms

[mdavid]

Hi,


I'm having a problem referring to controls on sub forms, below is the schema of how my forms are arranged:

Main Form


TabControl


Private Sub TabCtl0_Change()
Select Case Me.TabCtl0.Value
Case 0
Me.SubFormContainer.SourceObject = "SubForm1"
Case 1
Me.SubFormContainer.SourceObject = "SubForm2"
End Select
End Sub

Note: I think part of my problem is referring to controls on SubForm2 when it's not the SubFormContainer.SourceObject - ie. SubForm1 is loaded

SubFormContainer


Sub Form 1

Sub Form 1A - Continuous Form

Button- btnCopyMemp


Private Sub btnCopyMemp_Click()
If IsNull(SubForm2a.txtComplaint) Then
SubForm2A.txtComplaint = SubForm1A.txtComplaint
End If
End Sub

TextBox - txtComplaint

TextBox - txtPrep

TextBox - txtAdmin




Sub Form 1B - Continuous Form


Sub Form 2


Sub Form 2A


TextBox - txtComplaint


Sub Form 2B - Continuous Form

TextBox - txtPrep

TextBox - txtAdmin


How do I refer to the subform controls - in red- in the code for btnCopyMemp_Click() above?

I also need to copy txtPrep and txtAdmin from SubForm 1A to SubForm 2B - help referencing these controls also appreciated

Sorry lost indentation in above schema, hope it's still clear.

Thanks for any help
David

[alansidman]

http://www.datapigtechnologies.com/f.../subform2.html

[mdavid]

Hi thanks for this.
I did try as the link suggests but get an error saying "can't find the field SubForm2".

As I wrote (see Note before SubFormContainer) I think part of the problem is that SubForm2 is not loaded in the SubFormContainer

Thanks
David

[June7]

That would be a problem. Why dynamically loading objects? Is the form so complicated and slow?

[mdavid]

Hi June, thanks for confirming that's the problem, used this method 'cause I saw a video using it and liked the idea. I'll change it to normal tabs and let you know.
Hopefully mark this solved.

Thanks
David

[mdavid]

Silly question - can I add an existing form (with subforms) to a page in a tab control? Googled add existing form to page but only found adding fields

Thanks
David

[ArviLaanemets]

Activate the page you want to add the form into (NB! the page must be activated, not the form containing the tab control);
From object pane on left, drag the form into page;
Adjust created subform's (there will be now a subform on page with form as source) position and dimension. Preferably rename a subform so it doesn't have same name as form it contains;
In case you want the created subform to link to parent form, and the link was not created automatically (p.e. because parent form is unbound one), edit subform's properties to estabilish links.

[mdavid]

Thanks for this - I've already started copying the first page.
I'll try your method on the page2

[mdavid]

Thanks all,
All sorted and working

David