Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Sub Report Visibility

Status
Not open for further replies.

kb178

IS-IT--Management
Aug 16, 2001
83
US
I have a main report with 7 sub reports. Those subreports all have a bunch of subreports within them. When I put in the 6th subreport on the main form, I get a message saying "Cannot open any more tables." Right now I'm using the visible property to hide the other subreports, but is there a way to not have them try to open up? So instead of having Me.SubReport.Form.Visible = True, is there something like Me.SubReport.Form.Open?
 
I couldn't find 3.5, but found 4.0. And it didn't help. How do you open a recordset in a report? And do you put the code on Activate or on Open?
 
I'm still having problems having all my subforms opening up. Anybody know of a way to close a subform?
 
I'm still having problems having all my subforms opening up. Anybody know of a way to close a subform?

subFORMs or subREPORTS?...First you were talking about reports, then you started talking forms. Which is it? The answer depends on the difference.

Access Version?________________

Jet Version?____________

Service Releases installed?___________



Ex-JimAtTheFAA
78.5% of all statistics are made up on the spot.
Another free Access forum:
More Neat Access stuff at
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top