Intercepting error codes like 2220, file not found

[justphilip2003]

I have been attempting to intercept the screen message for a file not found following instruction { Me.ImgBox.Picture = GetPath() & "\Gallery_Pics\" & "CrNr963v1" & ".jpg"} and have my Event Procedure display a user friendly message to continue processing. My On error code directs processing to the error routine but the code "If Err.Number = 2220 Then ..." does not work and is skiped over to the "Else". Is it possible to intercept this error code? I will have many instances of executing this logic as the user pages through the multiple views to the not found condition. My logic works wonderfully when the records are found, thanks June7! TIA Phil

[rpeare]

on error goto errhandler

<your code here>

errhandler
if err.number = 2220 then 
   <do whatever you're going to do on this error>
else
   <do whatever you want if the error is other than 2220>
endif

[Missinglinq]

Don't know if it matters in your use, here, but Error 2220 is 'Access can't open the File, not 'cannot find the File.'

Linq ;0)>

[rpeare]

I'd like to add one more thing. If you are using filesystemobject commands you can test the path of the file before you try to do anything with it and avoid error trapping altogether

dim fs 
dim sTestFile as string

set fs = createobject("scripting.filesystemobject")
stestfile = = GetPath() & "\Gallery_Pics\" & "CrNr963v1" & ".jpg"
if fs.fileexists(stestfile) then
' you may also use if fs.fileexists(stestfile) = True then
  <do what you're going to do if the file exists>
else
  <do what you're going to do if the file does not exists>
endif

[justphilip2003]

Dumb me! in order to stop error screen displays, you must place the "On Error goto ..." statement before the code causing the error! Cheers and my thanks to all helping hands! Phil