hello experts,
Im a newbie in need of someone's experience. I have an image repository db that allows the input and search images just fine. However, if I want to erase an image, the subroutine doesn't allow it. I get a compile error everytime and I've tried to correct with no success. Here's the code:
Private Sub cmdErasePic_Click()
If Not IsNull([imageFile]) Then
If MsgBox("The image will be removed from this record. Are you sure?", vbYesNo + vbQuestion) = vbYes Then
[imgPicture].Picture = ""
[imageFile] = Null
SysCmd acSysCmdClearStatus
Call Form_Current
End If
End If
End Sub
The imgPicture is a part of the subform within the form. imageFile is the actual picture stored within the image table.
The message I get is "Microsoft Access can't find the field '|' referred to in your expression.What could I be missing? Please help...thanks in advance.