Here is a simple sub I wrote to use when I need to use different Queries for the same ComboBox:
I have a table for "Members" and one for "Prospects". My CheckBox indicates if a person is a "Member". This code allows me to easily enter the names of "Members" or "Prospects" as needed in my ComboBox.
Code:
Private Sub MycboBox_GotFocus()
If Me!myCheckBox = True Then
Me!MycboBox.RowSource = "Query1"
Else
Me!MycboBox.RowSource = "Query2"
End If
End Sub
Last edited by a moderator: