Hi,
The calendar "control" has to be in a form, and once there, the syntax to
query it is as with any control in an open form:
FORMS!FormName!ControlName
Those parameters are automatically evaluated for you if you use the user
interface, or if the statement is in a RowSource property, of if you use
DoCmd.RunSQL, as example. If you use CurrentDb, these parameters ARE NOT
automatically resolved, and you have to do it BEFORE execution of the query
using this syntax.
Hoping it may help,
Vanderghast, Access MVP