Let's say the Yes/No field is called chkPicture
Set the Visible property for chkPicture to No.
Make the OLE (picture) object Visible = Yes.
In the On Change event of the Yes/No field add the logic to see if it is
Yes/True.
If Me.chkPicture = True then
Me.olePicture = "C:\MyPicture.jpg" 'or whatever field or variable that
contains the file name
End If
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
