Filtering subforms from ActiveX date control

[Junkguy]

Hi,

I'm trying to make a form with the ActiveX Calendar in the main part which is
meant to restrict the records in the subforms. That is, when a user clicks on
a date in the Calendar, the subform records filter according to that date by
their date columns. The main form is not connected to any table.

I should mention that the records for the subform are coming from an external
database, so I'm a little concerned about speed here. I would prefer to filter
the records at the server end.

Has anyone done this before and how can it be done? Let me know if this is not
enough information.

Thanks!