If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Passing data to a report from an input box
I have reports created where the filter is created based on criteria chosen
from the calling report. Additionally, before the report opens, the user enters a beginning and ending date via an input box, and those dates are stored in variables. I have specified those variables in the arguments of the docmd.open report, and it works as planned, picks up the correct date. However, once the report is open, I want the beginning and ending dates to appear in text boxes on the report, specifically in the page header -- but can't seem to do that. Once the docmd open statement is run and the dates are used to filter the info that appears, the variables empty out, even though the calling report has not closed yet (so I would have thought they'd still be in scope). Is there a way of doing this that I'm just not seeing? Or do I need to make a whole form for thee inputs? Thanks. |
#2
|
|||
|
|||
Passing data to a report from an input box
Do you actually have a report call another report? Can you provide your
method/code for opening the report? You might want to play with a text box with a control source of: =[Filter] -- Duane Hookom MS Access MVP -- "KarenH" wrote in message ... I have reports created where the filter is created based on criteria chosen from the calling report. Additionally, before the report opens, the user enters a beginning and ending date via an input box, and those dates are stored in variables. I have specified those variables in the arguments of the docmd.open report, and it works as planned, picks up the correct date. However, once the report is open, I want the beginning and ending dates to appear in text boxes on the report, specifically in the page header -- but can't seem to do that. Once the docmd open statement is run and the dates are used to filter the info that appears, the variables empty out, even though the calling report has not closed yet (so I would have thought they'd still be in scope). Is there a way of doing this that I'm just not seeing? Or do I need to make a whole form for thee inputs? Thanks. |
#3
|
|||
|
|||
Passing data to a report from an input box
Oops, no, I mistyped. I have a FORM that calls the report, not a report
calling another report. The form calls many reports, including several that use different date fields (representing different dates), so I was hesitant to add more date fields that would be applicable only to this group of reports, lest it confuse the user. "Duane Hookom" wrote: Do you actually have a report call another report? Can you provide your method/code for opening the report? You might want to play with a text box with a control source of: =[Filter] -- Duane Hookom MS Access MVP -- "KarenH" wrote in message ... I have reports created where the filter is created based on criteria chosen from the calling report. Additionally, before the report opens, the user enters a beginning and ending date via an input box, and those dates are stored in variables. I have specified those variables in the arguments of the docmd.open report, and it works as planned, picks up the correct date. However, once the report is open, I want the beginning and ending dates to appear in text boxes on the report, specifically in the page header -- but can't seem to do that. Once the docmd open statement is run and the dates are used to filter the info that appears, the variables empty out, even though the calling report has not closed yet (so I would have thought they'd still be in scope). Is there a way of doing this that I'm just not seeing? Or do I need to make a whole form for thee inputs? Thanks. |
#4
|
|||
|
|||
Passing data to a report from an input box
Do you still have a problem? Did you read beyond the first sentence of my
reply? -- Duane Hookom MS Access MVP -- "KarenH" wrote in message ... Oops, no, I mistyped. I have a FORM that calls the report, not a report calling another report. The form calls many reports, including several that use different date fields (representing different dates), so I was hesitant to add more date fields that would be applicable only to this group of reports, lest it confuse the user. "Duane Hookom" wrote: Do you actually have a report call another report? Can you provide your method/code for opening the report? You might want to play with a text box with a control source of: =[Filter] -- Duane Hookom MS Access MVP -- "KarenH" wrote in message ... I have reports created where the filter is created based on criteria chosen from the calling report. Additionally, before the report opens, the user enters a beginning and ending date via an input box, and those dates are stored in variables. I have specified those variables in the arguments of the docmd.open report, and it works as planned, picks up the correct date. However, once the report is open, I want the beginning and ending dates to appear in text boxes on the report, specifically in the page header -- but can't seem to do that. Once the docmd open statement is run and the dates are used to filter the info that appears, the variables empty out, even though the calling report has not closed yet (so I would have thought they'd still be in scope). Is there a way of doing this that I'm just not seeing? Or do I need to make a whole form for thee inputs? Thanks. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Passing Active Form Name to Report Input Parameter (ADP) | Aad v via AccessMonster.com | Running & Setting Up Queries | 3 | September 6th, 2005 09:32 PM |
Unable to have multiple queries feeding a single report | PZ Straube | Setting Up & Running Reports | 15 | June 15th, 2005 08:16 AM |
Multiple worksheet queries | liam | Worksheet Functions | 3 | February 16th, 2005 06:52 PM |
SQL view of messed up action queries | Kendra | Running & Setting Up Queries | 2 | August 31st, 2004 09:53 PM |
How to create graphs in a monthly report where the base data can change | John Clarke | Charts and Charting | 3 | June 25th, 2004 02:22 AM |