View Single Post
Old 07-20-2019, 08:26 AM   #4
Newly Registered User
Join Date: Nov 2005
Location: Margate
Posts: 928
Thanks: 64
Thanked 48 Times in 41 Posts
MickJav will become famous soon enough
Re: Changing images on a Continuous Form

I do this a lot

If Not IsNull(Me![Picture]) Then
Me.Imgage1.Picture = Me![FoldersLoc] & Me![Picture]
Me![CmdRemove1].Enabled = True
End If

Imgage1 has its picture type set to linked
Me![FoldersLoc] is the loaction of my main storage folders
Me![Picture] is the field in the table holding its name only
Me![FoldersLoc] & Me![Picture] these can be one but if you move the folder you will have to update all linked pictures

If your only going to have a few you could create a table with there names and link then use a combo to select happy, sad Etc
All open code examples and free projects are only available from:

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

Last edited by MickJav; 07-20-2019 at 08:34 AM.
MickJav is offline   Reply With Quote