Changing image source

[Middlemarch]

My image control is bound to a query, but I'd like to conditionally change the picture but restore it when moving to another record.
I tried using a second image control and toggling visible as required but it didn't quite work out.
Can I have one image control and change it source between the query and an alternate picture file?
VBA seems to error when changing the control source, but I may be doing it incorrectly.

[orange]

Did you look at Similar Threads at the bottom of the page to see if any offered insight on an approach?
There is one marked SOLVED that has 7 posts.... worth a look.

It would be helpful if you posted some of your code and showed the problem area and what you'd like to achieve.

[Gicu]

Usually it is done by setting the Picture property of the image control in the Current event of the form; basically you would use Len(Dir(yourPath))=0 to check if the file supplied by the query exists (or maybe the query returns Null if no file available) and you set the Picture property to your alternate picture.

Cheers,

[Middlemarch]

Thank you. Have now changed to using a Form with Border style none (instead of an image control)
and the problem has gone away.

[June7]

All images are external from database? What condition for display of image files? Can have IIf() expression in ControlSource. I have never used Picture property for dynamic display of images.

[Middlemarch]

Yes the images are external. You gave me the instructions for using a query so the screen would not flicker as images changed.
I haven't changed that, this is a addition. It's all working as hoped except I cannot detect a click event in the picture.
The Form click event doesn't work and there's no Picture click event. So not sure how to resolve that.

[June7]

Image control has Click event. Why do you need it? You said you wanted image displayed according to a condition. What is that condition?

IIf() expression can be in query and Image control reference that calculated field or expression in ControlSource.

[Middlemarch]

I'm now using a Form to display a thumbnail size picture. It represents the current item in a datasheet.
I want that to open a larger resizable form showing the same picture.
But the Click event fails. Is there any way to make it work?

[June7]

Image control Click event works for me.

What do you mean by "fails" - error message, wrong result, nothing happens? Want to show code or provide files?

Pictures don't show on form in Datasheet view therefore can't click on Image control.

Not clear to me what you are doing.

[CJ_London]

initial requirement

I'd like to conditionally change the picture but restore it when moving to another record.

plus

I'm now using a Form to display a thumbnail size picture. It represents the current item in a datasheet.
I want that to open a larger resizable form showing the same picture.

equals confusion

[Middlemarch]

How come? Pretty straightforward I'd have thought. Maybe your first language isn't English ?
Read it again and think about what I've said.

[June7]

Can I have one image control and change it source between the query and an alternate picture file?

Direct answer is "yes". ControlSource of Image control can be an IIf() expression that determines whether to use field data for file location or static string for alternate image filename.

Then you state:

I'm now using a Form to display a thumbnail size picture. It represents the current item in a datasheet.
I want that to open a larger resizable form showing the same picture.
But the Click event fails. Is there any way to make it work?

Click event where - the thumbnail and this is an Image control? Again, show code or provide database.

As I said, Click event for Image control works for me. I have no idea what you have attempted.

[Middlemarch]

I changed the picture from an Image control to a Form using the Forms picture property.
But that Forms click event isn't working, whether the picture is present or not.
Should it? It's popup, not modal, not datasheet. and not using headers or footers.

[CarlettoFed]

Attach a sample file and everything will be faster.

[June7]

I tested. The event triggers only when I click on record selector at left side of form. If record selector is inactive, no click trigger.