Referencing a subreport on a tab control on a form

[Salty Mariner]

I'm having trouble with referencing a subreport on a tab control on a form.

The Form's name is frmPortListNew
the tab control's name is tabPortCalls
The tab it's on is named Page 51
the subreport is named rptSubPortList

My code is as follows

Private Sub cboFind_AfterUpdate()
Dim intPortID As Integer
Dim rst As DAO.Recordset


    intPortID = Me.cboFind.Value
    Set rst = Forms![frmPortListNew]![tabPortCalls]![Page51]![rptSubPortList].Report.RecordsetClone 'Assign the subreports recordsetclone to a vaiable
    
    rst.FindFirst "PortID = " & intPortID   ' find the first match
    
    If Not rst.NoMatch Then 'If a match is found
        [Forms]![frmPortListNew]![tabPortCalls]![Page51]![rptSubPortList].Report.Bookmark = rst.Bookmark 'Set the subreport's bookmark to the recordset's bookmark
    End If
    
End Sub

This seems like it should be mundane and simple enough but its throwing a runtime error 451 "Property let procedure not defined and property get procedure did not return an object."

The syntax for my references appear to be OK. What am I missing.

[Edgar]

You do not need to reference tabs or pages, the report is in the form inside a subform/subreport control. You need the name of that control for the syntax to be correct, like:
Forms![frmPortListNew]![SubreportControlName].Report.RecordsetClone

You can also simply go to the properties for that report, and set "has module" property to yes in the "other" tab.
Then, you will be able to forget about any syntax and directly reference the recordset clone property or any other property or method of the report like this:
Report_rptSubPortList.RecordsetClone

[Salty Mariner]

You do not need to reference tabs or pages, the report is in the form inside a subform/subreport control. You need the name of that control for the syntax to be correct, like:
Forms![frmPortListNew]![SubreportControlName].Report.RecordsetClone

You can also simply go to the properties for that report, and set "has module" property to yes in the "other" tab.
Then, you will be able to forget about any syntax and directly reference the recordset clone property or any other property or method of the report like this:
Report_rptSubPortList.RecordsetClone

Thank you for the response. I tried your suggestions, and many other variations and I am still not able to refer to the subreport. Something is not right because this should not be this hard. But then again I also have never tried referring to subreports before. That is why did the long form reference figuring that If it was explicitly referenced it should work.

[June7]

Only forms have a RecordsetClone because a report's dataset is not editable and editing RecordsetClone data edits the form dataset.

Also, apparently cannot even set a recordset variable to a report's Recordset - unless you are still working with ADP file.

Can set recordset variable with report's RecordSource.

What are you trying to accomplish?

[Salty Mariner]

Only forms have a RecordsetClone because a report's dataset is not editable and editing RecordsetClone data edits the form dataset.

Also, apparently cannot even set a recordset variable to a report's Recordset - unless you are still working with ADP file.

Can set recordset variable with report's RecordSource.

What are you trying to accomplish?

Simple Synchronization is what I was trying to accomplish. I was trying to make it behave like continuous forms. and visually it does. Apparently from what you have just said Navigation/synchronization is not possible. It's not a deal breaker for me by any means. I Have been exploring things like mixing forms and reports and I just learned a big limitation. I can certainly do things more conventionally.

Oddly, Microsoft Copilot was telling me this was entirely possible, plausible and even offered up several code samples. Go figure.

Thanks again June

[June7]

I am not understanding what you mean by synchronization and how a RecordsetClone would serve for that.

[Edgar]

I just checked and I agree with June7, we have a Recordset property for reports, but it will throw an error if you try to access it. There is no RecordsetClone property available for reports either.

What kind of synchronization/navigation are you talking about? If you're trying to "focus" on a certain record of the report, you could change the recordsource.

[Salty Mariner]

I just checked and I agree with June7, we have a Recordset property for reports, but it will throw an error if you try to access it. There is no RecordsetClone property available for reports either.

What kind of synchronization/navigation are you talking about? If you're trying to "focus" on a certain record of the report, you could change the recordsource.

Yes, that is basically all I was trying to do was focus on a record. I can just go back to using a continuous form..... It was interesting to toy around with some different ideas and ways of doing things. Of course i also found out about the limitations Thanks for chiming in. I always learn stuff from you guys.