Yet another inexplicable problem

[DataBug]

I have 2 Active X controls (calendar controls) on a form named "From" and "To". No matter what I do, I cannot reference these controls in a query. The query returns nothing and I get no error messages. I have no earthly idea why and I've pulled out my hair for 2 days trying to figure out why.

Any help appreciated.

btw: query criteria = Between [Forms]![Main]![From] And [Forms]![Main]![To]

Select query

 

[Rich]

Put two unbound texboxes on a form, put the dates from the calendar in them and refer to those boxes in your query. BTW you only need one calendar

 

[The_Doc_Man]

It has been ages, but as I recall, any ActiveX control has another layer in it because it is really a control inside an object. If you double click on the calendar object and then try to use F1 to open Help files, you might be lucky enough to get help on how to use the calendar objects from VBA.