chk box to filter or hide rows based on value in a column
Thanks Dave for the feedback......I added the propsed code and assigned
to a new forms control chk box.
When the box is checked, the code adds filter drop downs but does not
proceed to filter out the rows.
When the box is unchecked, the code excecution is interrupted because
the .ShowAll Data method fails
Any thoughts on how to overcome.....
Thx, Deano
|