Enter user defined field in report header

[joe789]

Greetings:

I have created a macro in which one of the append queries prompts the user for [START DATE] and [END DATE]. The macro uses these two values to correctly generate reports. The reports are perfect; however, I have a problem: On the header of each of the reports, I would like a text box that states the [START DATE] and [END DATE] the user entered to generate the reports. I have creating a textbox and entering the equation =[START DATE] but when I run the report, the textbox says #NAME?. Something else that is strange, Append Query fields are not listed in the Expression Builder?? Please help me. Thank you!!!!!

[This message has been edited by joe789 (edited 04-30-2001).]

 

[Ron Bell]

hese start dates and end dates are being entered into the SQL of your query, so cannot be picked
up by the textbox on report

Try using on a new form for users to enter dates: two new text boxes -
named eg "Date1" and "Date2"

and then add to your macro: Between [Forms]![newform]![Date1] And [Forms]![newform]![Date2]

Then in Report textbox controlsource:
=("Between " & [Forms]![newform]![Date1] & " and " & [Forms]![newform]![Date2])