Loading Image to Report based on a field in the report

[spidge32]

I use this code in a form to load a image from several based on the value of fldDiagName.

Option Compare Database
Option Explicit
Dim srcdoc1 As String

Private Sub Report_Load()

If IsNull([fldDiagName].Value) Then
srcdoc1 = DLookup("[tblBobbinDiagrams]![Diag Path & File]", "tblBobbinDiagrams", "[Bobbin Diag Type]='BLANK'")
Else
srcdoc1 = DLookup("[tblBobbinDiagrams]![Diag Path & File]", "tblBobbinDiagrams", "[Bobbin Diag Type]=[fldDiagName]")


End If

Diagram1Image.Picture = srcdoc1
Diagram2Image.Picture = srcdoc1
End Sub

When the report loads I get run time error '94', Invalid Use of Null.

Should I be put the event after the report has loaded?
If so where?

[orange]

Where is [fldDiagName] dimmed/defined?

[Micron]

Put a break point at the beginning then open the report and step through the code and let us know which line causes the error.
Please use code tags for sql and code (# on posting toolbar) and indentation to make it easier to read. That will also stop the forum software from inserting spaces where there are none.

[spidge32]

All the fields on the report are defined in a temporary table which has all the fields for the report

[Welshgasman]

Shouldn't you be concatenating flddiagname?

[spidge32]

Welshgasman, I'm very much a beginner at Access. I'm not sure what you mean by concatenating flddiagname.
I looked at the query from which is the report source and if you click on the Diag1.image, it shows the correct image.
I then tried by making the query create a table and used this as the report source, but again the image is not shown.
Either way works just fine using a combo box in the entry form for the database.

[spidge32]

Micron, when I put break point on any part of the code the error occurs.
I looked at the query from which is the report source and if you click on the Diag1.image, it shows the correct image.
I then tried by making the query create a table and used this as the report source, but again the image is not shown.
Either way works just fine using a combo box in the entry form for the database.

[Micron]

There was more to what I suggested

then open the report and step through the code and let us know which line causes the error.