Parameter Prompt

[Kila]

I have a report in Access 2007 that is based on a query that has:

Between [Forms]![fdlgDateRange]![txtStartDate] And [Forms]![fdlgDateRange]![txtEndDate]

...in a Date field. The report has several subreports that are based on crosstab queries based on the original query.

We used to tweak the date field of the primary query manually, but today I changed it to a the text above and added a macro to the report that opens and closes the query (which becomes invisible when you click "OK") when you open and close the report.

Why would the report keep prompting you to enter the date when the query has the text above in it. It eventually opens if you keep pasting the above into the parameter window that opens, after you do it several times...more times than the number of subreports in the query even!

Help!

 

[wiklendt]

can you post a sanitised version of your database? with brief description which report and which query are involved?

 

[JANR]

Is the Form fdlgDateRange open when you execute your macro? The Promt indicates that it is not.

JR