Image Forms

[kevin24]

I have a simple query on a table which gives most recent (date added)image details.
I wish to be able to show all the images from the query.
I only get the first image to show.
I need some guidance how I set up a form correctly. Thanks

 

[cookiegary01]

If I understand correctly, your query is set up fine and you now made a form from that query but you only see the first record on your form.
When you move to the nect record in your form you see the next record and next picture but you want all records on your screen together.
If so then you need to change the form to a continuous form.
Select the Properties of the form. Then change the Default view to "continuous".

 

[kevin24]

Thanks for your response.

My fault I did not explain properly.

When the form opens I want it to show all the
images without any action from the user.

So if the query shows 20 items, there would be 20
images on the form.

Thanks

 

[G37Sam]

Are we talking about a continuous form?

 

[kevin24]

As I understand it

 

[cookiegary01]

Create a Continuous form using a wizard:
-Select Form New
-Select Autoform - Tabular
-Select the query
-Select OK
The form is created for you.
Now check the design view of the form to learn how it is set up.

 

[kevin24]

Thanks for that most helpful. However I cannot work it out how to have a form as per my included example.

The pictures would of course all be different and I would want a label
under each.

Many thaks your patience

 

[cookiegary01]

Can't be done in a form as far as I know.
You'll get 1 different picture per row.

Row 1.... Picture 1
Row 2.... Picture 2
Row 3... Picture 3