passing Date info to report from a form

J

J. Lund

I have a form which asks for a start and end dates. Those dates are then
used for a record selection query to produce a report. The query and report
work. However, is there a way to pass the start and end dates (from the
form) to the report? The dates would then be used to show the date
selection criteria used in producing this report. Any help would be
appreciated.
 
F

fredg

I have a form which asks for a start and end dates. Those dates are then
used for a record selection query to produce a report. The query and report
work. However, is there a way to pass the start and end dates (from the
form) to the report? The dates would then be used to show the date
selection criteria used in producing this report. Any help would be
appreciated.
Click to expand...

Add an unbound control to the Report Header.
Set it's control source to:
="For Sales between " & forms!FormName!StartControlName & " and " &
forms!FormName!EndControlName

Change FormName to the actual name of the form.
Change StartControlName and EndControlName to the actual name of those
controls on the form.
The form MUST be open when the report is run.
 
Top