Sub-report not reading date from main report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've created a report with a sub-report that contains warranty data. The main
report contains a date that I need to replicate in the sub-report.

Issue: How can I have the sub-report automatically match the date entered in
the main report date field? These 2 dates need to match. I would prefer not
to key in the date a second time within the sub-report.

Background: I've tried to set the default value of the property of the date
field in the sub-report to match the value entered in the main report. This
value does not show in the sub-report and I'm not sure why.

Thanks in advance for all your help.
 
To display the date in the main report's text box within the subreport, try
setting the ControlSource of the text box to:
=[Report].[Parent]![NameOfDateBoxOnMainReportHere]
 
Allen,
That works, but...
The date does not display until after I close the form. How do I make the
date display after I update the Main report's date? I'm a newbie to this
area. Thanks for your patience. Your solution gets me 50% of the way to my
goal.

Allen Browne said:
To display the date in the main report's text box within the subreport, try
setting the ControlSource of the text box to:
=[Report].[Parent]![NameOfDateBoxOnMainReportHere]

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

dab1477 said:
I've created a report with a sub-report that contains warranty data. The
main
report contains a date that I need to replicate in the sub-report.

Issue: How can I have the sub-report automatically match the date entered
in
the main report date field? These 2 dates need to match. I would prefer
not
to key in the date a second time within the sub-report.

Background: I've tried to set the default value of the property of the
date
field in the sub-report to match the value entered in the main report.
This
value does not show in the sub-report and I'm not sure why.

Thanks in advance for all your help.
Click to expand...
Click to expand...
 
You lost me.

The date displays in your subreport only after you close what form? And how
do you update a date in a report?

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

dab1477 said:
Allen,
That works, but...
The date does not display until after I close the form. How do I make the
date display after I update the Main report's date? I'm a newbie to this
area. Thanks for your patience. Your solution gets me 50% of the way to
my
goal.

Allen Browne said:
To display the date in the main report's text box within the subreport,
try
setting the ControlSource of the text box to:
=[Report].[Parent]![NameOfDateBoxOnMainReportHere]


dab1477 said:
I've created a report with a sub-report that contains warranty data.
The
main
report contains a date that I need to replicate in the sub-report.

Issue: How can I have the sub-report automatically match the date
entered
in
the main report date field? These 2 dates need to match. I would prefer
not
to key in the date a second time within the sub-report.

Background: I've tried to set the default value of the property of the
date
field in the sub-report to match the value entered in the main report.
This
value does not show in the sub-report and I'm not sure why.

Thanks in advance for all your help.
Click to expand...
Click to expand...
Click to expand...
 
Sorry Allen! I used the word "report", when in fact it as a form. I was
creating a form not a report. My mistake. The date was not a date - I may
have Alzheimers!, it was a Warranty Claim# I was trying to update that
stemmed from a query that fed the report . Either way...You got me 50% to my
goal. Now... What can be done to have the Warranty Claim#, located in the
sub-form update after I tab through the field. Thanks for getting me started!

Allen Browne said:
You lost me.

The date displays in your subreport only after you close what form? And how
do you update a date in a report?

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

dab1477 said:
Allen,
That works, but...
The date does not display until after I close the form. How do I make the
date display after I update the Main report's date? I'm a newbie to this
area. Thanks for your patience. Your solution gets me 50% of the way to
my
goal.

Allen Browne said:
To display the date in the main report's text box within the subreport,
try
setting the ControlSource of the text box to:
=[Report].[Parent]![NameOfDateBoxOnMainReportHere]


I've created a report with a sub-report that contains warranty data.
The
main
report contains a date that I need to replicate in the sub-report.

Issue: How can I have the sub-report automatically match the date
entered
in
the main report date field? These 2 dates need to match. I would prefer
not
to key in the date a second time within the sub-report.

Background: I've tried to set the default value of the property of the
date
field in the sub-report to match the value entered in the main report.
This
value does not show in the sub-report and I'm not sure why.

Thanks in advance for all your help.
Click to expand...
Click to expand...
Click to expand...
 
Okay, can I suggest that - now you have the question worked out - you ask it
in the group relating to forms?

Thanks.
 
Back
Top