bound Objects Frame

[Phil]

Hi,

I have a database with over 1000 records and am trying to create a bound
Object frame to link each record with a photo(not in the database - they are
located on a CD). East record in the databse has a unique number, each
picture has the same number with the externsion .tiff.

What I need is(if possible)

1: How to create the bound object for the table
2: How to code it so that I do not have to amend each record individually as
this would take quite a long time.
3: How to set this up on a form so that each records phots is
linked/displayed automatically as I traverse through them.
4: If I need to make any amendments how easy would this be

I dont have much experience in programming so the exact steps would be needed.

Many thanks

Phil

 

[mscertified]

I have done this by interting an image control (from the toolbar).
If you look at its properties, you will see the 'Picture' property is the
path to the image.
All you need do in the 'on current' event of your form is to load that
property with the path to your image (e.g. Me!MyImage.Picture =
"C:\Myimage.jpg"). As you move from record to record the image will change.

-Dorian

 

[Phil]

Thanks for the reply Dorian,

This has been very helpful so far.
I have tried your suggestion and all works well until I am entering the
details in "on Current" - Its looks for a macro when I try to open after
enteringthe details.

The way I have set up is

Record 1, 123456 Pict in c:\pic\123456.jpg
Record 2, 123123 Pict in c:\pic\123123.jpg
etc etc
I must have entered something incorrectly.
Can you shed any light on it???

Thanks