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?.

The MonthView control's are called monthDateFrom and monthDateTo.

So far I have this:

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

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

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:

[VBA]
DoCmd.OpenReport "rptFormReport", acViewPreview
[/VBA]

[Marcster]

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

Ooops!...

Works like it should now .