||Re: Closing an image on a form
Mervyn Bick <email@example.com>
||Wed, 7 Apr 2021 14:09:22 +0200
On 2021/04/07 00:47, roy price wrote:
> Hello Mervyn,
> I'm not sure where this proposed solution gets me. The sql statements restrict the selection to "where ID ='1'", or "where ID='2'''
> So I only see two records with ID 1 or 2.
> Most of the responses to my question just recommend image editing software to reduce file sizes. But that does not answer the problem.
> The images are on three separate files which are linked by a common fieldname to the main table.
> Roy Price
I'm afraid that was me doing my favourite (only :-) ) exercise namely
jumping to a conclusion.
You have three tables so it implies that you have three separate queries
accessing these tables. Each query creates a separate rowset. The
example was intended to show that to display an image from a different
rowset all you need to do is change the assignment to the image controls
form.image1.dataSource = form.fish1.rowset.fields["fish image"]
form.image1.dataSource = form.fish2.rowset.fields["fish image"]
immediately displays the selected image in the second file.
You have three separate files. For the example I used the only table in
the samples database which has images twice. To make sure each rowset
displayed a different image (so that the change was obvious) I added the
where clause to each query.