Date field not passing to report

[mdaccess]

Hi There,

I can't seem to work out why this isn't working. I have a form with a macro button to go to my customer report. The form has 2 date fields created called 'ReportStartPeriod' and 'ReportEndPeriod'. When you enter the dates and click the macro I am presented with a Parameter query box instead of my report with only people referred between these two dates???? What is really odd is that if I enter dates here the result works just fine. What is wrong with my date fields?

Here is my WHERE condition within the macro... [ConsumerT]![ReferralDate] Between [ReportStartPeriod] And [ReportEndPeriod]

Any advice much appreciated.

[pbaldy]

In a macro I think you need the full form reference. In VBA it looks like:

http://www.baldyweb.com/wherecondition.htm