using wildcards with a combo box

[michael1p]

Hi

Im trying to create a query that uses a combo box as the filter criteria. However the combo box needs to use wildcards, which i would have thought would have been *[forms]![control]![combo1]*. However this doesnt seem to work, anyone know what im missing?


Cheers

Michael

 

[ajetrumpet]

Michael,

try this...

 LIKE (*) & [forms]![control]![combo1] & (*);

Michael, your code should also read like this...

LIKE (*) & [forms]![form name]![control name] & (*)

"combo1" IS the "control name"