Batteredburrito
New member
- Local time
- Today, 22:06
- Joined
- May 17, 2016
- Messages
- 1
ComboBox filter to populate ListBox
I currently have an issue with filtering results from a table named "Solutions"
It has coloumns named "Manufacturer","Model","User" and "SolutionText"
On a form named "Troubleshooting" I have two comboboxes name "cboManfact" and "cboModel" I also have a text box named "SolutionSearch"
What I need is for the Listbox "SolutionView" to display as follows:
When "cboManfact" has a user selected value, update "SolutionView" with "SolutionText" where "Manufacturer" = "cboManfact" value
Also when a value in "cboModel" is selected. Keep the results using the "cboManfact" value previously but add another filter where "SolutionText" = "Previous search" and "Model"
I need for each of these to act individually and preferably be unbound to table "Solutions" as there is another form that adds data to this table.
Once i have this, i will then need to filter the results one last time using the text box input, but that is for later
I hope it makes sense as im currently :banghead: with this issue. Its been a while since ive used VBA but aim to understand what you guys say and will give as much info as needed.
Thanks for your time and let me know what you need
I currently have an issue with filtering results from a table named "Solutions"
It has coloumns named "Manufacturer","Model","User" and "SolutionText"
On a form named "Troubleshooting" I have two comboboxes name "cboManfact" and "cboModel" I also have a text box named "SolutionSearch"
What I need is for the Listbox "SolutionView" to display as follows:
When "cboManfact" has a user selected value, update "SolutionView" with "SolutionText" where "Manufacturer" = "cboManfact" value
Also when a value in "cboModel" is selected. Keep the results using the "cboManfact" value previously but add another filter where "SolutionText" = "Previous search" and "Model"
I need for each of these to act individually and preferably be unbound to table "Solutions" as there is another form that adds data to this table.
Once i have this, i will then need to filter the results one last time using the text box input, but that is for later
I hope it makes sense as im currently :banghead: with this issue. Its been a while since ive used VBA but aim to understand what you guys say and will give as much info as needed.
Thanks for your time and let me know what you need
Last edited:
