Criteria to search any part of the field

M

Marco

Hi. I use to use this criteria to make searches in my query. This allow me
put search records that has that criteria.

Search form "laptop" it will show:

"Asus Laptop" and "This is a HP Laptop"

For some reason is not working anymoe
ALike "*" & [Forms]![4_form_Goods_View]![Goods_Name] & "*"

The problem is that it's not working anymore.

Anyone knows way?

Regards,
Marco
 
J

John Spencer

I believe with ALike you need to use "%" as the wildcard instead of "*" and
use "_" in place of "?".

Hope that helps.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
Top