picture linking subform

[2ippy]

I'm having a problem with my sub forms and the sample linking image code.

Top subform is in data view and the bottom in form. Sync'd with a textbox.

notes show individual data per record as you click on them, and the picture updates the location the same.

Problem I am having is that the picture does not display even though the path is there.

 

[2ippy]

bumpy bump

 

[lightray]

I think you'd have better luck if you post the relevant code

 

[2ippy]

all the code works as is, but the pictures don't display though the paths are there.

more than welcome to have a look.

 

[lightray]

Hi 2ippy, have a look at the my changes and tell me if this is how you want it to work. I have been able to insert a standard windows backgound image into the database. However if it stores the link (rightly so)you will not see the image.
What I did change was the link that wasn't linking in the bottom subform, and inserted the Customer file into the relationship table so I could understand it better. hope its what you want
lightray

 

[2ippy]

could you post the database please so i can have a look

 

[lightray]

Sorry, I thought I had uploaded it! This time

 

[2ippy]

you actually broke it. I tried a 3rd subform and it's working as it should now the images display.

 

[lightray]

you actually broke it. I tried a 3rd subform and it's working as it should now the images display.

I would still suggest that the problem was in the link between the subform and the main form, and you have re-established it correctly when you created the 3rd subform.


having said I broke it , what actually happened? lightray

 

[2ippy]

the linking between the notes subform and the main subform was broken.

 

[lightray]

Interesting! I went back and checked a few things and noticed that you are coding for 2002 - 2003. I don't know if it makes a difference but I code for 2000 format.
Glad you got it sorted, a good test for problems with a subform, when all exhausted attempts have failed, is to delete it off the main form and them re add it. quite often it fixes it