Filter report

J

JHM WINE

Am I failing with the syntax or am I trying to do the impossible? I simply want
to show records which are "like" a string input. Please tell me what is wrong
with this line:

DoCmd.OpenReport "Deeds2", acViewPreview, WhereCondition:="MATTER Like Locate"


Locate is the input and MATTER is the name of one of the fields.

John Martin
 
D

Dan Artuso

Hi,
Probably something like this:
DoCmd.OpenReport "Deeds2", acViewPreview, WhereCondition:="[MATTER] Like '*Locate*'"
 
Top