I have a form that has 3 combo boxes with possible entries for each different category. I am having a couple different problems.
1. When I only choose an entry type for the first category, the query pulls some of the results. But it is no where near what that particular one should produce. Not sure what is causing it to do that.
2. I am not sure exactly to have it set up so that if the user is not sure on one or two of the categories and they just leave them blank it still operates the correct way.
The query is pulling the information from two tables that are directly related to one another so that shouldn't be a problem. The form is using information from the same two tables as possible entries.
Any help would be great.
Thanks in advance