Go Back   Access World Forums > Microsoft Access Discussion > Reports

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 12-02-2015, 08:18 PM   #1
scopes456
Newly Registered User
 
Join Date: Feb 2013
Posts: 89
Thanks: 55
Thanked 2 Times in 1 Post
scopes456 is on a distinguished road
Open sub report from main report by selecting report name

I have a daily summary report that list the names of reports that was filled out for the. Given day.i would like to click on the report name from the main report and it will open up the report that I click. Fox example today main report shows that we fill out Clean log,Supplies update,Safety check. I would like to click on those report name and it will open the report.

I try doing this with sub reports ur sub reports displayed reports that wasn't filled out for the given day. And I wanted the report to just show what was done that day.

scopes456 is offline   Reply With Quote
Old 12-03-2015, 08:26 PM   #2
llkhoutx
Newly Registered User
 
Join Date: Feb 2001
Location: Houston,Texas USA
Posts: 4,018
Thanks: 6
Thanked 106 Times in 104 Posts
llkhoutx is on a distinguished road
Re: Open sub report from main report by selecting report name

You can't select the subreport after the report is opened except by using a blank subreport, the sourceobject of which is determined on the format {whatever} section the subreport is located.

Alternativlely, have several reports, each with a different subreport and determine which t open.
__________________
Get the job done right, rather than do the right job.
Do it fast or do it right. Teach a man a fish . . .
If it ain't broke, don't fix it.
Note that I don't open posted databases, period.
llkhoutx is offline   Reply With Quote
The Following User Says Thank You to llkhoutx For This Useful Post:
scopes456 (12-15-2015)
Old 12-07-2015, 06:50 AM   #3
Velid
Newly Registered User
 
Join Date: Sep 2008
Posts: 6
Thanks: 0
Thanked 1 Time in 1 Post
Velid is on a distinguished road
Re: Open sub report from main report by selecting report name

In access 2013 you can use View Report (acViewReport) to open main report, which will allow you to create On Click events for all elements in your report - just use this to open report with criteria for given day.

I used this to create a summary list for next 10 days in report, and when you click any of the days, it opens sub-report for given day.

Velid is offline   Reply With Quote
The Following User Says Thank You to Velid For This Useful Post:
scopes456 (12-15-2015)
Old 12-15-2015, 11:01 AM   #4
scopes456
Newly Registered User
 
Join Date: Feb 2013
Posts: 89
Thanks: 55
Thanked 2 Times in 1 Post
scopes456 is on a distinguished road
Re: Open sub report from main report by selecting report name

velid, llkhoutox thank you for the information , was able to come up with a soultion

scopes456 is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Is it possible to open a report with the Access main window hidden? Cavman Reports 6 07-18-2014 05:02 AM
Open Record By Selecting Control in Report dr_destructo Reports 1 10-04-2010 11:23 AM
selecting report to open by Yes or No flect Modules & VBA 6 07-21-2008 06:52 AM
Passing result of main report query to sub report as parameter pompey1 Reports 6 06-23-2008 05:39 AM
Selecting a record to be shown on report open tanzania Reports 2 11-22-2006 05:34 AM




All times are GMT -8. The time now is 01:02 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World