Filter report

  • Thread starter Thread starter JHM WINE
  • Start date Start date
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
 
Hi,
Probably something like this:
DoCmd.OpenReport "Deeds2", acViewPreview, WhereCondition:="[MATTER] Like '*Locate*'"
 
Back
Top