File Path determines image imbeded in report - Not working

[brharrii]

I am using the following code to imbed an image on my report.

Option Compare Database
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If IsNull(Me.ImagePath) Then
 Me.ImgPic.Picture = "O:\Bellingham\Intranet\Production\Labels\WIP\wip.bmp"
 Else
 Me.ImgPic.Picture = Me.ImagePath
 End If
End Sub

I've used it before and never had problems with it, but now it only works intermitently. For certain records it works fine, for others it gives me an error message that says that a custom macro failed to run and then when I push debug it displays my code and highlights the line:



"Me.ImgPic.Picture = Me.ImagePath"

I've verified that the path in ImagePath is correct on both records. What else could I be missing?

Thanks!

[brharrii]

This ended up being an issue with the source code of the report. I had messed up a join on one of my tables and it ended up causing problems when I tried to run a report.

Thanks all!