J
Jon
I must be missing something pretty obvious, but I'm a
newbie, so maybe someone can help me. I have a form
(called Invoices) with only 2 things on it: a combo box
with years in it (2000, 2001, 2002, 2003, etc.), and a
subform. The subform is based on a query which uses the
years ([forms]![invoices]![cboYear]) to show only invoices
for the year you select. It works fine when I first open
the form. If I click the "Filter by Form" or "Filter by
Selection" button on the toolbar, it still seems to work.
But when I hit the funnel to remove the filter, it will
never work again after that. I did notice that the years,
which are numeric, turn to text after the filter is
removed, but even when I change them back (me.cboYear=Val
(me.cboYear)), it still doesn't work. Can anyone help me?
Thanks
newbie, so maybe someone can help me. I have a form
(called Invoices) with only 2 things on it: a combo box
with years in it (2000, 2001, 2002, 2003, etc.), and a
subform. The subform is based on a query which uses the
years ([forms]![invoices]![cboYear]) to show only invoices
for the year you select. It works fine when I first open
the form. If I click the "Filter by Form" or "Filter by
Selection" button on the toolbar, it still seems to work.
But when I hit the funnel to remove the filter, it will
never work again after that. I did notice that the years,
which are numeric, turn to text after the filter is
removed, but even when I change them back (me.cboYear=Val
(me.cboYear)), it still doesn't work. Can anyone help me?
Thanks