I have 3 combo box's in MS Access 2013
Manufacture, Brand, Product Group
When I filter on one combo box I want the other 2 combo box's reflect results of filter.
So when one Combo box is filter than the other two would combo's would be populated with result of selection.
This can be done easy in a Excel spreadsheet but not quit but having a difficult time during with Combo box's in a MS Access form.
For Example let's say I have 3 columns with this data in Excel:
MFG, Brand, Product Group
GLC, Great Lakes, 2 lb Rigid Packs
GLC, Great Lakes, Shreds
GLC, Thoughtful Organics, Organic Bar
GLC, Thoughtful Organics, Organic Shingle Slice
GLC, Adams Reserve, Cracker Cuts
After Filtering with the Product Group "Shreds"
I would like the combo box 1= "GLC" and combo 2 "Great Lakes" and the 3 combo box display filter Selection "Shreds".
=========
Thank you I greatly appreciate any help on this.
Manufacture, Brand, Product Group
When I filter on one combo box I want the other 2 combo box's reflect results of filter.
So when one Combo box is filter than the other two would combo's would be populated with result of selection.
This can be done easy in a Excel spreadsheet but not quit but having a difficult time during with Combo box's in a MS Access form.
For Example let's say I have 3 columns with this data in Excel:
MFG, Brand, Product Group
GLC, Great Lakes, 2 lb Rigid Packs
GLC, Great Lakes, Shreds
GLC, Thoughtful Organics, Organic Bar
GLC, Thoughtful Organics, Organic Shingle Slice
GLC, Adams Reserve, Cracker Cuts
After Filtering with the Product Group "Shreds"
I would like the combo box 1= "GLC" and combo 2 "Great Lakes" and the 3 combo box display filter Selection "Shreds".
=========
Thank you I greatly appreciate any help on this.
Comment