So, I ran into a problem and I've been trying to find an answer to it in this forum. It's related to the parital text search problem that I'm having but with a twist. I try and search the forum the best I can before I post...
I created a combo box whose values aren't in a query table, but each combo box value corresponds to data that I want to search for in the query.
User selects "Alpha" from the combo box.
"Alpha" actually corresponds to the partial text values of "A123", "B123" and "C123" which are in the query table. So, if the user selects Alpha, what would the code be to search through the column(s) to look for any or all of those values?
I'm guessing it would look something like this...
If cboGroup.Value = "Alpha" Then
'The following is definitely wrong...so what would go here?
Set SearchValue = "A123" Or "B123" Or "C123"
'ElseIf cboGroup.Value = "Beta" Then
Any help is extremely appreciated!