Display images from several records on one form

[seducedbycodes]

Hi,
Just wondering if there is any way to display an image (not just its name) within a datasheet. I don't think this is possible but maybe there is some way around it.

I have made a form to display a quote and need to show images of all parts that have been quoted, the images are stored in a table with the information about the part. I'm having trouble because the number of parts that will be on the quote is not set and i do not know how to add image boxes at runtime for only the number of parts on the quote. Hope that makes sense. Any suggestions on the best way to do this?

Thanks
Bek

 

[lupins46]

Can't you use a continuous form instead of a datasheet?

 

[seducedbycodes]

silly me ... thankyou for that suggestion.
one more query though, how do you make a continuous subform adjust its size depending on the number of records it is displaying and all elements in the master form move down depending on the size of the subform

 

[lupins46]

You would normally use scroll bars in continuous forms.