Photos On Forms

[Grumm]

I think this is an easy one but I have looked through previous posts and cant find the solution.

I have a form where I want to enable the users to insert upto 4 pictures per record. These are specified as tables in the tables as Photo1, Photo2 etc. To insert the photo on the form I right click and navigate to the oicture and copy it. It dislays in the box but when I goto the next record and back agint it doesnt display.

When I chose the file (instead of copying the picture) it displays the icon which i need to be displayed as the picture,

Any help would be great.

Thanks

 

[LittleSmudge]

As a general guide you would be MUCH better off storing the \\Server\Path\FileName string in a test field in the database and keep the actual image file outside of the database. This is a structural issue which will mean your form opens faster and the database file size does not balloon in size.


Then have a text box control on the form that is bound to the field and in the form's On_Current event
PictureBox1.Picture = TextBox1
PictureBox2.Picture = TextBox2
PictureBox3.Picture = TextBox3
PictureBox4.Picture = TextBox4



'ope-that-'elps.





G LS
accessaceNOJUNK@valleyalley.co.uk
Remove the NOJUNK to use.