Parameter Values

[kenone]

I have a report that is based on an underlying query.At the query level,I have defined parameters of date data type so that records to be displayed should fall between DateA and Date B.ie Between[Enter Date A:] And [Enter Date B:].How can I display these two parameter values on the report header???

[KGComputers]

hi kenone!!!

In one of my applications, I used a form using two textboxes to send data to query as basis for my report using data report designer...

One textbox for the beginning date(Date A) and one textbox for the ending date (Date B).

here is the code:


'to display the beginning date
rptSalesReport.Sections("ReportHeader").Controls(2).Caption = frmSalesReport.txtStart.Text

'to display the ending date
rptSalesReport.Sections("ReportHeader").Controls(3).Caption = frmSalesReport.txtEnd.Text



Controls(2) and Controls(3) are the controls on the report header section with the correct indexes..frmSalesReport is the form with the two textbox...Or you may substitute it with the control name...Hope this will help you.... :) :) :)