VBA can use like and wildcards to match items
IF Something Like "AB*" Then
If you are trying to search records in SQL then the syntax is similar.
If that little bit does not help you, please describe your problem a bit more
fully. What are you attempting to accomplish? Where?
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County