Ok. I got it now.
The problem was that the "Make" Field was not on the report. I was having trouble calling it from the table. The simplest solution for me was simply to add the field and set the visible property to no.
It works perfectly now.
I cleaned it up and added a msgbox for if it doesn't return a path:
Code:
Private Sub Report_Load()
Dim logoPath As String
'Load logo image based on make selected in current record
logoPath = Nz(DLookup("txtPath", "tblLogos", "[Manufacturer] ='" & [Make] & "'"))
If LenB(logoPath) <> 0 Then
imgLogo.Picture = logoPath
Else
MsgBox "There is no logo set up for this manufacturer. Check the Make or set up a logo", vbExclamation + vbOKOnly, "Missing Logo Image"
End If
logoPath = vbNullString
End Sub
Thank you all for your help!