Adding form fields to report

  • Thread starter Thread starter CEV
  • Start date Start date
C

CEV

Hi, I have a form where I enter a beginning and an ending date. After I
enter any date I want, I have a button that opens a report and shows me
certain information for the records that are between these 2 dates. How can
I have these 2 dates show up on my report so that I can easily tell the date
range for these records?

Thanks,

CEV
 
Hi, I have a form where I enter a beginning and an ending date. After I
enter any date I want, I have a button that opens a report and shows me
certain information for the records that are between these 2 dates. How can
I have these 2 dates show up on my report so that I can easily tell the date
range for these records?

Thanks,

CEV
Click to expand...

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

The form must be open when the report is run.
 
Thank you very much!! That worked.

CEV

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

The form must be open when the report is run.
Click to expand...
 
Back
Top