Problem with filtering a subform.

  • Thread starter Thread starter Jeffrey K. Ries
  • Start date Start date
J

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
 
Jeffrey,

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

Shelly
 
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
 
Back
Top