My table is setup like this
Issue Number
Category 1
Category 2
Issue Detal
Category 1 & 2 fields are assigned standard codes/categories such as AR, AP, INV etc... to classify each each. Two categories are necessary because some issues could relate to two different categories.
I have created a form with a combo box that allows me to select one of the standard codes and filters data using category 1 to give me all issues with (for example) AR in category one.
I would like to modify the form so that from a combo box, I can select one of the standard codes and the data is filtered using categor 1 & 2.
For example I select AR and I get all issues with AR in category 1 and category 2.
I just can't seem to get Access to like the idea of selecting from both categories.
Any ideas that could be offered would be greatly appreciated. Thank you.
Issue Number
Category 1
Category 2
Issue Detal
Category 1 & 2 fields are assigned standard codes/categories such as AR, AP, INV etc... to classify each each. Two categories are necessary because some issues could relate to two different categories.
I have created a form with a combo box that allows me to select one of the standard codes and filters data using category 1 to give me all issues with (for example) AR in category one.
I would like to modify the form so that from a combo box, I can select one of the standard codes and the data is filtered using categor 1 & 2.
For example I select AR and I get all issues with AR in category 1 and category 2.
I just can't seem to get Access to like the idea of selecting from both categories.
Any ideas that could be offered would be greatly appreciated. Thank you.
