Combo box quits after filter is removed

  • Thread starter Thread starter Jon
  • Start date Start date
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
 
You dont need to use the filter at all. Instead open the form in design view
and right click on the edge of the subform control, select properties. set
the child and master link fields to the combo box and the date field of the
subform. now when you change the combobox value the subforms information
changes automatically.
HTH
 
Thank you. That's exactly what I needed.

-----Original Message-----
You dont need to use the filter at all. Instead open the form in design view
and right click on the edge of the subform control, select properties. set
the child and master link fields to the combo box and the date field of the
subform. now when you change the combobox value the subforms information
changes automatically.
HTH
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
Click to expand...


.
Click to expand...
 
Back
Top