find method

  • Thread starter Thread starter Peter Fuller
  • Start date Start date
P

Peter Fuller

set oContact = oItems.Find("[business fax]=(888) 555" & Chr(45) & "2235")
set oContact = oItems.Find("[business fax]=(888) 555-2235")
set oContact = oItems.Find("[business fax]=(888) 555" & "-" & "2235")

all three give error: unable to parse condition. error ar "555"


any ideas?
 
When searching a text field, the value you are searching for needs to be in
quotation marks. Try:

strFind = "[BusinessFaxNumber]=" & Chr(34) & "(888) 555-2235" & Chr(34)
set oContact = oItems.Find(strFind)
 
Back
Top