I have some instances where I need to search for a particular value that has a special character in it. For example:
.findfirst AthleteName = "Rob O'Connell"

This returns an error. invalid syntax.

If I try to put square brackets [] around the field I get a different error - field name not valid

The following is the actual syntax used:-

rs.FindFirst "[AthleteName] = '" & Me![cboAthleteName] & "'"

Thanks for your help.

Paul

__________________
Paul

This should fix your problem
rs.FindFirst "[AthleteName] = '" & Replace(Me.cboAthleteName, "'", "''") & "'"



I am a loud man with a very large hat. This means I am in charge