Image Refresh

[Guest]

Hi,

I have a form which has X records. Each record has different image(s)
associated with it shown on the form (From the File System not in Access) I
have some VBA which changes the images as the record selectors are changed
and this works fine. (The file name for the image is in a field on the
records.

The problem : When i do a Docmd.printout , all records print but because the
record selectors where not clicked the images displayed do not change/update
(same images(s) appear with each record. I tried to use a text field with
"=Pages" to trap the record movement event but this not work.

A solution would be if i could trap a "Next record" type of event or loop
through the records and print one at a time.

Any pointers would be much appreciated.

Cheers,
Olan

 

[Guest]

hi,
not sure how you have it set up but printing images
associated with records....
see this site. i have used it. it works.

http://www.microsoft-
accesssolutions.co.uk/bound_image_report.htm

 

[Mark M]

Perhaps you should design a report and print that, instead of printing your
form. Otherwise, you'll have to filter your form to just the one record you
want to print.

 

[Arvin Meyer]

Do not print the form, use a report and put the same VBA code in the Format
event of the section where the image is.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access