Sub-report not reading date from main report

[dab1477]

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.

 

[Allen Browne]

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]

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.

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.

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.

 

[Allen Browne]

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.

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.

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.

 

[dab1477]

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!

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.

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.

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.

 

[Allen Browne]

Okay, can I suggest that - now you have the question worked out - you ask it
in the group relating to forms?

Thanks.