Hi All,
I'm having a problem getting my multiple criteria query to work and was hoping someone could shed some light.
I have a form with three unbound search fields (Product, Category and Issue Name) and an unbound combobox (Issue ID) that would contain all matching records, based on what's been entered in the other 3 fields. This Issue ID field, the result set, is the record source for a subform.
My goal is have the user move through the 3 search fields and have the resulting record set filtered as they go. For example, when they open the form all 3 fields are empty and the combobox result set would contain ALL issue IDs. Then they enter info in the first and then the second fields and the issue ID combobox would reflect the matching records. If and when the user selects an actual issue name from the last field then there would be only 1 resulting record and this should be reflected in the form.
It is this very last step that is not working. One can filter the result set via the first 2 fields (Product and Category) but entering an issue name produced no (0) records.
Even as I write this I suspect there is probably a better way to do this and if so I would appreciate the feedback. Or perhaps you can see the problem. I have attached the pertinent part of my DB so you can see what I am talking about.
Hope this makes sense
Thanks in advance!
Arch
I'm having a problem getting my multiple criteria query to work and was hoping someone could shed some light.
I have a form with three unbound search fields (Product, Category and Issue Name) and an unbound combobox (Issue ID) that would contain all matching records, based on what's been entered in the other 3 fields. This Issue ID field, the result set, is the record source for a subform.
My goal is have the user move through the 3 search fields and have the resulting record set filtered as they go. For example, when they open the form all 3 fields are empty and the combobox result set would contain ALL issue IDs. Then they enter info in the first and then the second fields and the issue ID combobox would reflect the matching records. If and when the user selects an actual issue name from the last field then there would be only 1 resulting record and this should be reflected in the form.
It is this very last step that is not working. One can filter the result set via the first 2 fields (Product and Category) but entering an issue name produced no (0) records.
Even as I write this I suspect there is probably a better way to do this and if so I would appreciate the feedback. Or perhaps you can see the problem. I have attached the pertinent part of my DB so you can see what I am talking about.
Hope this makes sense
Thanks in advance!
Arch
