Darrylle
The problem I have goes like this:
I have a form with 4 image controls "imgCtrl1" to "imgCtrl4" presented across the form. The control source for the form is a crosstab query whith a datasheet that looks something like.....
[row_num] [1] [2] [3] [4]
1 path1 path2 path3 path4
2 path5 path6 path7 path8
3 path9 path10 path11 path12
(path1 etc. is actually a DOS path like "C:\picture.jpg"
Code run during the OnLoad event looks something like....
imgCtrl1.Picture = [1].Value
imgCtrl2.Picture = [2].Value
imgCtrl3.Picture = [3].Value
imgCtrl4.Picture = [4].Value
And this works perfectly. imgCtrl1 displays the picture at path1, imgCtrl2 displays the picture at path2 etc.
The problem is, the 2nd and 3rd rows of pictures are identical to the first because each row on a continuous form comprises the same controls as each other row. i.e. the controls on row one are imgCtrl1, imgCtr2 etc AND the controls on row 2 of the form are also imgCtrl1, imgCtrl2...
See what I mean?
I'm sure I'm approaching this from completely the wrong angle.
Regards
Damien