JMongi
Active member
- Local time
- Today, 02:28
- Joined
- Jan 6, 2021
- Messages
- 802
I've decided to use an unbound combobox to select between two queries as recordsources for my form. Here is the code in the AfterUpdate event of the combobox:
I realize the if/then really only works with having two options. I need to rework it for more than 2. But, the main issue is that it doesn't work! Ha! What am I missing?
Code:
Private Sub Combo20_AfterUpdate()
If Me.Combo20.Value = "Active List" Then
Me.RecordSource = "QryProjSummaryActive"
Else
Me.RecordSource = "QryProjSummary"
End If
Me.Requery
End Sub
I realize the if/then really only works with having two options. I need to rework it for more than 2. But, the main issue is that it doesn't work! Ha! What am I missing?