Form with no picture

[jmeek]

I have a form which brings up another form like this

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "frmImage"

stLinkCriteria = "[ProductID]=" & "'" & Me![txtProductID] & "'"
Me.Visible = False
DoCmd.OpenForm stDocName, , , , , , "SELECT ProductID, Description, Path FROM tblProducts WHERE " & stLinkCriteria & ";"

However, on the frmImage there is also an ImageControl that may or may
not have a picture. The name of the path and filename is stored in a field
in a table (not OLE).

I do not want the frmImage to open at all if no image can be found under the path and name specified. The file/picture name is exactly the same as the ProductID in the link criteria above.
Perhaps a message to say that no image was found.
At the moment the form opens up regardless.

By the way, the Me.Visible = False refers to the form that opens the
frmImage form, so will have to become True if no image found.

Thanks

 

[ScottGem]

See other reply.