I have a report that generates an output based on a parameter query whereby a user specifies the start date for all the courses details a user wants to output. What I want to do is store the value they enter and have this value listed on the report. Is this possible?

Gaz

__________________
Gaz

Are you using a form for the user to input the dates? If so, leave the form open, and pass the values to the report like this in an unbound text box with the control source of:

="Between " & [Forms]![frmName]![StartDate] & " - " & [Forms]![frmName]![EndDate]

When the report closes, close the form which was used for the dates.

Regards,

Beth M

I am having to keep the database as basic as possible as the end users of the database want to develop the database themselves at a later stage when they get up to speed with Access. Therefore, I am avoiding having to use Macros or VBA as much as possible. I thought it would be easy but making the database as basic as possible have caused no end of set back.

So, in answer to your question I am actually running a basic parameter based query specified in one of the database field values in the query design window

Gaz

Unfortunately, I don't believe you can pass the values used as criteria unless you first use a form which actually holds the values while the report is opened. When you close the report, you would also close the form.

If you want more details, let me know.

Beth M