Picture Overlays to a Sub Form

[Compmike19]

Is there an automated way to populate a sub form with an image in the same position to overlay another image if a checkbox is checked from a table. Would I have to lay an image object for every record manually?

This is for a video game map. The base map is 100x100 pixels, then each map modification will overlay a 100x100 pixel image (mostly transparent) with a few pixels not. I can lay them manually, then toggle them with the checkbox, but would like for Access to read each record, create a picture object in the same location, load it with the filename from the field, and set it invisible unless the checkbox is marked. Is this possible? I have almost 400 images to overlay, manually sounds tedious and inefficient.

 

[theDBguy]

Hi. Welcome to AWF!

Are we talking about a continuous form?

 

[Compmike19]

Single form, the map image and overlays would be the constant, be they in a sub form, or the main form. I do not want to replace an image but to have an image (mostly transparent overlay) in place for every record and visible based on the true/false checkbox field of the record.

 

[June7]

Where are these map images - Attachment field or file folder? If folder, I would probably use expression in ControlSource property of Image control.
Review https://www.accessforums.net/showthread.php?t=73766

 

[Compmike19]

In a file folder, Filename in the table, using the ControlSource is fine. So, it still looks like I have to manually place an Image control for each record, to reference the field so I do not overwrite the image.

 

[June7]

In a file folder, Filename in the table, using the ControlSource is fine. So, it still looks like I have to manually place an Image control for each record, to reference the field so I do not overwrite the image.

I am not understanding this. An Image control can dynamically display image per record, just like any other data control dynamically displays data.