I have two choices in a form's combobox. They are "Alex" and "Ted".
In a query then I am using this criteria in a column:
Like "*" & [Forms]![frmNameSelection]![cboSelection] & "*"
If I select Ted in the combobox and run the query I get just the "Ted" records. But if I select "Alex" I get all records.
What am I doing wrong?