Solved: ActiveX MonthView Controls

[Marcster]

How do you use two ActiveX MonthView control's which are on a form called frmReports in a criteria field in a Query,
so the query will only select records between the two MonthView dates?. :dunno

The MonthView control's are called monthDateFrom and monthDateTo.

So far I have this:

Between [forms]![frmReports]![monthDateFrom] And [forms]![frmReports]![monthDateTo]

But the report selects no records and I know there are records between those dates. :banghead:

Or should I be using something else?.


Thanks,

Marcster.

[Norie]

Is the form actually displayed when you try this query?

[Marcster]

Hi Norie,

Yes the form is displayed.
The query is run after a button on the form is pressed.
The code behide the button is:


DoCmd.OpenReport "rptFormReport", acViewPreview

[Marcster]

I've noticed what the problem was.
There was a spelling mistake in part of the Query which I didn't post above! :doh:

Ooops!...

Works like it should now :yes .