Hi all,
I'm trying to filter a form and really struggling with it. I've spent some time searching the forum and tried the various solutions posted and can't get it done.
I want to filter products based on a checkbox, so a list of around 1000 products filters to show only the 100 or so 'active' products.
I can get it filtered by using the filters in Access and I can filter it by querying it but I really want to get it done with a button.
Any thoughts? Thanks in advance.
I'm trying to filter a form and really struggling with it. I've spent some time searching the forum and tried the various solutions posted and can't get it done.
I want to filter products based on a checkbox, so a list of around 1000 products filters to show only the 100 or so 'active' products.
I can get it filtered by using the filters in Access and I can filter it by querying it but I really want to get it done with a button.
Any thoughts? Thanks in advance.