Hi guys, I got a form with entries like
*name
*shop
*due date
I made a tabbed page on that form with unbound combo boxes that display all the name,shops, due dates possible.
I used
docmd.requery
docmd.applyfilter "name = [forms]![form].[filtername]
where filtername is the name of the combobox that has name entries. I'm able to filter ok by one thing. But, I want to use multiple combo boxes to "dynamically" filter the data on the form. Help.
*name
*shop
*due date
I made a tabbed page on that form with unbound combo boxes that display all the name,shops, due dates possible.
I used
docmd.requery
docmd.applyfilter "name = [forms]![form].[filtername]
where filtername is the name of the combobox that has name entries. I'm able to filter ok by one thing. But, I want to use multiple combo boxes to "dynamically" filter the data on the form. Help.