Hi, I have a sub form which displays the columns on one table (via a query). The sub form also contains several combo boxes - each referring to columns on the table which i would like the users to use to filter the table with. I would like the combos to work both dependently and independently of each other to filter the table.
When the sub form is loaded, i would like it by default to show every row on the table, and then after this, the user has the option of filtering the results based upon the combo boxes. They may choose to only use one combo box or they may choose to use them all, but I can’t see to get this to work!
How do you do this?
Thanks.
When the sub form is loaded, i would like it by default to show every row on the table, and then after this, the user has the option of filtering the results based upon the combo boxes. They may choose to only use one combo box or they may choose to use them all, but I can’t see to get this to work!
How do you do this?
Thanks.
