Change Image via Macro Designer Access 2010

[joseinazusa]

I am have an Image Control call Gauge



I need to know how to change the Picture value of the Gauge Control using the Macro Designer, IE: change from image2.jpg to image1.jpg or image3.jpg

I tried set property

(Set Property)
Gauge.Picture
Value
image2.jpg

Just not sure who to use the Macro Designer to change the image.

[June7]

I don't know that macros can change properties.

Is this an Image control or an OLEObject control?

Where are the images? Are they in Attachment field or external?

If external need the file folder path.

I find it easier to use an Image control and dynamically set its ControlSource property.

[joseinazusa]

It is a Image control. Images are in the same folder as the access file,

That is the question.

How could I change the ControlSource Property using the Macro Designer?

Thank you.

[June7]

You have only the 3 images? What condition determines which image should display?

As stated, I don't know that macros can change properties. I use only VBA. However, with the ControlSource property of Image control, neither code method might be required.

[joseinazusa]

I think I just found the limitation of the Macro Designer. Just using VBA Code was easier.