I hate to ask this question, but I'm getting nowhere fast.
I have a straightforward combobox based on a table. I need the values available on the form to be filtered by a second field in the table so that if one condition is met, a tempvar takes on a value, and in all other cases, it takes on a value including a wildcard to cover several available options. So I've currently got (though I've tried several options)
This just sets the TempVars to filter the underlying query. Column 1 has the values to show up in the combobox, and column 2 has either CCA, CCP, or some version of OIT (could have others in the future). For CCA and CCP it works fine, but the 'OIT*' is not returning anything, so I'm obviously just not calling it correctly and everything is getting filtered out. I can't believe this is taking me so long, but... Monday.
I have a straightforward combobox based on a table. I need the values available on the form to be filtered by a second field in the table so that if one condition is met, a tempvar takes on a value, and in all other cases, it takes on a value including a wildcard to cover several available options. So I've currently got (though I've tried several options)
Code:
Private Sub Form_Load()
Dim caseCode As String
Dim fltr As TempVars
caseCode = Me.ReportingAgency.Value
Select Case caseCode
Case "CCA", "CCP"
TempVars!fltr = caseCode
Case Else
TempVars!fltr = "Like 'OIT*'"
End Select
End Sub