I have a query that asks the user to enter a range of dates. Basically in the criteria line, I have this...

Between [Enter Beginning Date] and [Enter End Date]

Now, in my report in the report header, it looks like this...

Major Projects Report

"Between 7/1/2005 and 12/31/2005"

Now, as it is now, you have to manually go in and type the dates in that box. How can I set it up so that when the user inputs their dates from the query, it will be applied to a text box or something so they do not have to go in and manually change their date range?

Thanks anyone for help.

One way would be to have the user enter the start dates and end dates in 2 text boxes on a form. The criteria for your query could point to the form.
For the report create a new text box and you could set the value to = "Between" & " " & [forms]![form1].[start date] & " " & "and " & [forms]![form1].[end date]

** [start date] and [end date] would be the names of the text boxes on the form.

Thanks for your help. I'm out for the day, but I'll check that tomorrow. thanks again.

I would agree with manrav that a form would be a good way to go.
For now you can add a text box and set its controo source to
="Between " & [Enter Beginning Date] & " and " & [Enter End Date]

What do I put in the query to have it point to the form? Something like this...

Field: Finish_Date
Table: Project_Table
Criteria: Between [forms]![DateRangeFormTextBox].[BeginningDate] And [forms]![DateRangeFormTextBox].[end date]

When I put that in, an error message comes up saying..
"Enter Parameter Value"
"Forms!DateRangeFormTextBox.BeginningDate"

What is the problem here?

The syntax is correct.

Make sure sure of the control names