set recordsource of a form in a not linked split form

[diegomarino]

Hi


i made a split form with two not related forms:


the one in the left called "nav" is just to open other forms, the bigger one on the right is called "candidati" and the split main form is called "lista calendario"


in the right form "lista calendario" i used the C button to navigate to a form called "candidatiS1" that was a single form. Now i made a split form adding the same "Nav" form as you can see, and i gave the name "candidatis1" to the split form and the old "candidatis1" (the single form) now is called "candidati"




this is the code i used to navigate to the single form, now i'm not able to set the recordsource of the "candidati" form in the split form "CandidatiS1"

Private Sub Comando494_Click()   If CurrentProject.AllForms("candidatis1").IsLoaded = True Then
      Forms!candidatis1.RecordSource = "SELECT Candidati.* FROM Candidati WHERE (((Candidati.IDcandidato)= " & Me.Candidato & "));"
      DoCmd.OpenForm "candidatis1", acNormal, , , acFormReadOnly, acWindowNormal
   Else
      DoCmd.OpenForm "candidatis1", acNormal, , , acFormReadOnly, acWindowNormal, Me.Candidato
   End If
End Sub

[CarlettoFed]

If you don't attach an example file, replacing any sensitive data, it will be difficult to help you.

[diegomarino]

thanks very much, i found the solution

if you want to set a recordsource of a form in a split form and you are in another form this is the reference method

Forms.SplitForm.SingleForm.Form.RecordSource

if you want to open a split form and set the recordsource of a form in it this is the reference method to put in the "open event" of the split form

Me!SingleForm.Form.RecordSource

thanks for the help, till next

[pbaldy]

FYI, the term "split form" refers to a specific type of form, which yours is not. That makes it a little confusing. What you have is referred to as a subform on a main form. This is a split form:

https://support.microsoft.com/en-us/...b-86e79a1fbe1e

[diegomarino]

you're right. that was a translation issue, sorry.
i just made a form composed by two unrelated forms. i thought it was called "split form" too

[pbaldy]

Nothing to be sorry about, I just wanted to clarify the terms.