Hi
I hope I explain this properly!
I have a query that includes three fields, "Group", "SubGroup" and "StockItem" where the items in subgroup are related to groups and stockitems are related to subgroups.
I have a form where the user selects each of these from separate comboboxes.
At present, to run the query I have referenced each of these to the form combobox fields in the query criteria.
That is fine if all I want to see is the data for the stockitem field, as all three criteria are applied, and works really well.
What I would like to achieve is essentially a drill down of the data in stages.
If the user selects the group combo then the data shows all items for the entire group. If they then select a subgroup under that group then only the data for the subgroup is displayed and finally if they select the stockitem then only that data is displayed.
As I cannot edit the criteria in a query programmatically, I am not sure how to achieve this.
Would really appreciate any assistance on this.
Thanks
I hope I explain this properly!
I have a query that includes three fields, "Group", "SubGroup" and "StockItem" where the items in subgroup are related to groups and stockitems are related to subgroups.
I have a form where the user selects each of these from separate comboboxes.
At present, to run the query I have referenced each of these to the form combobox fields in the query criteria.
That is fine if all I want to see is the data for the stockitem field, as all three criteria are applied, and works really well.
What I would like to achieve is essentially a drill down of the data in stages.
If the user selects the group combo then the data shows all items for the entire group. If they then select a subgroup under that group then only the data for the subgroup is displayed and finally if they select the stockitem then only that data is displayed.
As I cannot edit the criteria in a query programmatically, I am not sure how to achieve this.
Would really appreciate any assistance on this.
Thanks