I'm using a list box to display categories. I reference the list box in a query in the criteria section under category. So i have a subform with all the parts which i can filter depending on the category a select in the main form.
I|t filters the results fine. However, I am trying to remove the filter so all records are shown. I have tried numerous options like putting a "*" in the category list thinking it would feed that into the query but it came up blank.
Is there a way to ignore the category criteria and show all the parts?
Could you post a link to the thread that helped you fix it? I'm assuming it was discovered that you cannot remove part of a filter, but must remove the whole filter or recreate it without the component you were trying to leave out?