I'm using an embedded macro using a combo box. When I build the embedded macro I use an IF statement to open a report and the report is feed by a query. When I enter an exact value in the Where clause, the report executes perfectly and I receive all the desired records. However, I want to use a wildcard in the Where clause, when I do that it doesn't seem to work.
For example, Where Condition = [Query1]![Name] = "Smith" I correctly get all Smith records. BUT, if I try to use a wildcard like [Name] = "Sm*", I get no records