Header titles

[Sgt Bilkp]

Hi,

I have a form frmRunReport that runs a report based on a query. The query requests a date range for the report (from and to) and outputs the report based on this range. This is done through two text boxes on frmRunReport, and they are txtFrom and txtTo.

Ii want to be able to display the input range on the form header for printing purposes. Is there any easy way to do this?

eg: "Courses undertaken between From and To"

 

[boblarson]

If you leave the form open you can just put a textbox on the report with this control source:

="Courses undertaken between " & [Forms]![frmRunReport]![txtFrom] & " and " & [Forms]![frmRunReport]![txtTo]

 

[Sgt Bilkp]

Spot on bob!