The problem code:
------------------------------------------------------------------
targetRS.FindFirst "DocumentName_App='" & !DocumentName_App & "'"
------------------------------------------------------------------

throws RunTime Error 3077 Syntax Error (Missing operator in
expression)


The problem expression resolves thusly:
------------------------------------------------------------------
?"DocumentName_App='" & !DocumentName_App & "'"
DocumentName_App='Deal000579.Hewett's+Island+CLO+V +Note+Valuation+Report+08.30.2011.pdf'
------------------------------------------------------------------

Clearly it's the apostrophe in "Hewett's" and I could wimp out by
just stripping out embedded apostrophes in any file names I come
across during the process - so they never get to FindFirst.

But I'm guessing there's a "right" way to deal with this.

Replacing the single apostrophe with two apostrophes makes the
error go away. As in Whatever = Replace(Whatever, "'", "''")

But I don't know what I'm getting in to there. Is FindFirst
then looking for just ...Hewlet's..., or is it now looking for
....Hewlet''s...?

Can anybody elucidate?
--
PeteCresswell

Per (PeteCresswell):
OK, dumb question.....

The answer, FWIW, is that FindFirst is now looking for the
correct value ...Hewlet's...

The double apostrophe gets converted on-the-fly to a single
apostrophe as it is fed to FindFirst.
--
PeteCresswell

On Oct 11, 4:29*am, "(PeteCresswell)" <x...@y.Invalid> wrote:
Option to try
I had a problem with apostrophes for a name lookup search function on
a form.
Problem code - DoCmd.ApplyFilter , "Name = '" & strFilter & "'"
Good code - DoCmd.ApplyFilter , "Name = " & Chr(34) & strFilter &
Chr(34)
The advice given to me was to replace the apostrophe with Chr(43)
You then can do not need to worry about the "" characters
This worked well for me
Names with apostrophes were my problem.
Cheers
Duncan