G
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
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