Problem with filtering a subform.

[Jeffrey K. Ries]

I am working on a form which I would like a subform to repopulate itself
depending on the entries selected in two combo boxes. I have the form and
subform created and working well and I have a query created which can filter
the subform through ONE of the two combo boxes. When I add the criteria for
the second combo box (date) I get zero results - this is incorrect. Is
there some trick to filtering with a date?

Thanks,
Jeffrey K. Ries

 

[Shelly]

Jeffrey,

Sometimes Access requires dates to be surrounded by #
symbols in criteria statements.

Shelly

 

[Jeffrey K. Ries]

I am merely linking to a combo box which contains a date. Do I still need
to somehow add the #s to the criteria? If so, how do I do it? I tried to
simply add the #s at the start and end of the criteria and it errored out.

Thanks,
Jeffrey K. Ries