Embedded Macro using Where Condition = clause and selection criteria with wildcards does not workk

[Texam1970]

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

[June7]

Try:

[Name] LIKE "Sm*"

[Texam1970]

It worked GREAT, thanks so much!!