Hi there.
Can I have combobox value or text with wildcard as criteria of a query, so that I can search with partial value of a field? For instance a cell value in my Import_ID field is "2020-21 BHM Con 3" which is text. I wish to have an Unbound combobox "Station" in a form whose value suppose I select BHM. So in my query criteria I put
Like "*" & "[Forms]![Form1]![Station]" & "*"
It should fetch BHM from Station combobox and should return the above mentioned record ie "2020-21 BHM Con 3".
But it returns nothing.