Change subform sourceobject and go to specific record in subform by ID

[accessbro]

I have a main form with a continuous form as the source object in the subform control. There's a button on the continuous subform that changes the subform source object to a single form but when the subform source object is changed, it always goes to the first record in the single form. I want the single subform to show the record with the same ID as the record in the continuous form. I have tried:

Forms![Main Form]![Subform].Form.SourceObject = "singleSubForm"
Forms![Main Form]![Subform].Form.Filter = "[ID]=" & Me![ID]
Forms![Main Form]![Subform].Form.FilterOn = true

Forms![Main Form]![Subform].Form.SourceObject = "singleSubForm"
With Forms![Main Form]![Subform].Form.Recordset
.FindFirst "ID=" & Me![ID]
End With



Forms![Main Form]![SubForm].Form.SourceObject = "singleSubForm"
Forms![Main Form]![Subform].Form.RecordSource = "SELECT * FROM Query1 WHERE [ID] =" & Me![ID]

How can I make it so that when I click on the button in the record in continuous subform, the subform source object changes to a single form and goes to the record with the same ID as the record in the continuous form where the user pressed the button?

[June7]

SourceObject is a property of the subform container, not the form held by the container. Is Subform actually the name of the container?

Me.Parent.[subformcontainername].SourceObject = "singleSubForm"


Do you really need to change the SourceObject property? Are there really two different forms? Or do you just need to change the DefaultView property of the form object?

[accessbro]

Technically the name of the subform container is something like Child27 right now.

I'm experimenting with my form design where everything is displayed in a subform in the main navigation form. The continuous form and subform record source are based on the same query but the single form provides more details. I want the user to be able to click on the record in the continuous form so that the subform displays the record with more detail. My approach was by changing it to the single form but it always goes to the first record. I want it to go to the record with the same ID as the continuous form record.

[June7]

I just tested trying to change DefaultView property. Requires form to be open in Design. Scrap that idea.



First set a variable with the ID value.

intID = Me!ID
Forms![Main Form].Child27.SourceObject = "singleSubForm"
Forms![Main Form].Child27.Form.Filter = "[ID]=" & intID
Forms![Main Form].Child27.Form.FilterOn = True

Alternatively, button can be in the main form.
intID = Me.Child27!ID
Me.Child27.SourceObject = "singleSubForm"
Me.Child27.Form.Filter = "[ID]=" & intID
Me.Child27.Form.FilterOn = True

[accessbro]

I figured it out. singleSubform is actually the subform in the form that's used in the subform in the main form.

Forms![Main Form].Child27.Form.Child0.Form.Filter = "[ID]=" & intID
Forms![Main Form].Child27.Form.Child0.Form.FilterOn = True