Greetings,
I'm using Access 97. I've searched on Combo AND Filter, but have not seen what I need.
I have a table called BUDGET. On a form I would like to have 3 Combo boxes that are used as a filter.
I need to filter on three fields; CAC, ObjCls, Output.
So far there are over 5000 records in this database. I've created separate tables that hold the information on the above fields. I did this just to get rid of the duplicates.
I would like the user to use a combo to select a CAC (Cost Account Code), example = 33101. This would display all records with CAC 33101.
Then the user would select an ObjCls (Object Class Code) from the second combo box, example = 2111. This would return all records with CAC 33101 and ObjCls 2111.
Finally, the user would select an Output (Output Code) from the final combo box, example = 009. This would return all records with CAC 33101, ObjCls 2111, and Output 009.
I have two different forms set up. One form gets all of it's information from a query called Budget. The only filtering I can do so far is to right-click on a column (CAC) and enter the CAC I want. I then do the same with ObjCls and Output. This is cumbersome.
My second form uses a form-subform setup. I created a table (t_CAC_Codes), and have a combo box that selects a CAC code. This returns all records in a SubForm (sb_Cost_Transfer_DETAIL), which gets it information from a Query (q_Budget). The CAC combo works fine, since the main form is bound to the table t_CAC_Codes.
I'm not sure what the best route is to do this. Any help would be appreciated.
Bob in Indy.
I'm using Access 97. I've searched on Combo AND Filter, but have not seen what I need.
I have a table called BUDGET. On a form I would like to have 3 Combo boxes that are used as a filter.
I need to filter on three fields; CAC, ObjCls, Output.
So far there are over 5000 records in this database. I've created separate tables that hold the information on the above fields. I did this just to get rid of the duplicates.
I would like the user to use a combo to select a CAC (Cost Account Code), example = 33101. This would display all records with CAC 33101.
Then the user would select an ObjCls (Object Class Code) from the second combo box, example = 2111. This would return all records with CAC 33101 and ObjCls 2111.
Finally, the user would select an Output (Output Code) from the final combo box, example = 009. This would return all records with CAC 33101, ObjCls 2111, and Output 009.
I have two different forms set up. One form gets all of it's information from a query called Budget. The only filtering I can do so far is to right-click on a column (CAC) and enter the CAC I want. I then do the same with ObjCls and Output. This is cumbersome.
My second form uses a form-subform setup. I created a table (t_CAC_Codes), and have a combo box that selects a CAC code. This returns all records in a SubForm (sb_Cost_Transfer_DETAIL), which gets it information from a Query (q_Budget). The CAC combo works fine, since the main form is bound to the table t_CAC_Codes.
I'm not sure what the best route is to do this. Any help would be appreciated.
Bob in Indy.
