I want to set the value of a combo box to wildcard. I have it where they have to select a name from the combo box that is populated with names from a table. The problem is when they want to pull all the names. I can't get the combo box set to wildcard.
It looks something like this.
If chkEmployee = True Then
cmbEmployee.Value = cmbEmployee.Value
Else.
cmbEmployee.value = (what I cant figure out)
End If
This value is link into a criteria field into a query. And I know to pull a wildcard like that I would use Like '*', but when I put that as the value it doesn't work.
Thanks in advance
Bookmarks