Continuous subform picture problem

[Costa Zu]

Hello,

Problem:

I have created a continuous subform with a button containing an image.
When I open the subform all the buttons use the same image as the
first record in the query that I am using. I want the button to
display the image it's corresponding record. How do I correct this?

Background:

The database I am creating is a library of car photographs. A query
is created based on make, model, style (coupe etc.) and colour. Thus,
with a few simple clicks I can choose all red Farrari coupes, for
example. This would then produce a list of vehicles that I have
photographed displayed as a series of thumbnail buttons. I would then
scroll to the one I want and click the button, which would open a
library of images. I have over 200,000 images.

 

[Allen Browne]

The simplest and least expensive long-term solution will be to upgrade to
Office 2007.

The Image control in Access 2007 has a Control Source.
You can bind it to a Text field that contains the file name.
Access will then display the picture for each record without code.
And it all works in Continuous View.

Earlier versions of Access cannot do that without resorting to a third-party
add-in. The new version makes it so simple, that this decision is a
no-brainer.

 

[Costa Zu]

Hi Allen,

Interesting comment. Unfortunately 2007 is not available in
Australia. I don't know why, but I checked with my supplier and they
are only selling 2003 with a free upgrade. Perhaps I'll have to wait.

Do you know of any 3rd party apps that will do the trick?

Cheers

Costa.