Combobox replace navigation tabs to show report

[ss6857]

Hello, I'm going to try to be as detailed as possible without being confusing! I am using the latest version of Access. What I am trying to do is create a form that lists all the reports that I have made. When the user selects the report he wants, it previews the report. Then there will be checkboxes of options such as, convert to excel, convert to pdf, print, email, etc...



But I am having trouble connecting the combobox and the subform..

In the original navigation form I chose (the ones with tabs), if I click and drag or type in a report name to the tabs it would preview the report on the subform. But because I have so many reports, having all those tabs would look busy and be less user friendly. So, what I want is if I click on a report in the combobox, I would like it to preview, but I can't seem to make that connection between the combobox and the subform/subreport.

Right now, the Link Master Fields is Child36 (the name of my subform) and the Link Child Fields is MSysObjects.Name. (this is when I click on my subform)
For my combobox my rowsourcetype is table/query and my rowsource is SELECT MSysObjects.Name FROM MsysObjects WHERE (Left$([Name],1)<>"~") And (MSysObjects.Type)=-32764 ORDER BY MSysObjects.Name;

Any suggestions? Thanks for any and all help!

[pbaldy]

If I'm understanding correctly, you can set the subform's source object property to the name of the report in the combo (in other words you'd use a single subform).

[ss6857]

I can't do that.. for example if I have two reports (Apples and Oranges) and I set the source object of the subform to Report.Apples it will only show the Apples report, no matter what report name I choose in the combo box. I want the report showing to change according to the report name chosen in the combo box

[pbaldy]

You misunderstand me. I mean you set it in code after the user makes a selection in the combo. That way it changes to whatever report they've selected.

[ss6857]

Ok.. Now I understand. Now I'm having trouble with my code!

So Far I have..
Private Sub Child36_Enter()
Dim rn As String
rn = (Combo7.Value) 'This is showing that rn=2, not rn=Oranges
Me.Child36.SourceObject = Report.rn 'This is just showing Me.Child36.SourceObject = ""
End Sub

I did have Combo7.Text, but then it was showing that rn = ""

[pbaldy]

That's odd since the only column you have in the combo is the name (I thought about the parentheses forcing a boolean result, but that wouldn't be 2). For clarity, in case it's confused about objects, try

rn = Forms!FormName.Combo7.Value

[ss6857]

nothing changed.

[pbaldy]

Can you post the db here?

[ss6857]

I made some leeway. I took my code and put in under the combo box under "on click." It is now reading that rn = "Apples" but it still reads the child36 as "".

Private Sub Combo7_Click()
Dim rn As String
rn = Me.Combo7.Text
Me.Child36.SourceObject = Report.rn
End Sub

[pbaldy]

This should simply be:

Me.Child36.SourceObject = rn

[ss6857]

Private Sub Combo7_Change()
Dim rn As String
rn = "Report." & Me.Combo7.Text
Me.Child36.SourceObject = rn
End Sub

Thank you so much for all your patience and help in figuring this out!!

[pbaldy]

It's working? I wouldn't have thought the "Report" part necessary, but I've never tried to put a report into a subform.