Printing form: image fails to update

[stellar0645]

Hello:



I have a form that includes an image - the image is tied to a key number on the form so that a different image appears as the records change. The code to fetch the image is an Event procedure in the form properties (On current) (I don't know if this is part of the problem):

Option Compare Database

Private Sub Form_Current()

Me!Image49.Picture = [Image_Path]

End Sub

As I page through the records, the images change to match the key number, no problem.

Problem: When I Print Preview or Print, the same image is printed for every record - there is no updating during the print process.

The images are not in the MDB but are stored on the hard drive with their location in [Image_Path].

Any thoughts on what is causing this? I need to print these records WITH the proper image.

Thank You . . . . .

[Guus2005]

You might want to add the DoEvents command to let windows run other jobs such as screenupdates.

Enjoy!

[stellar0645]

You might want to add the DoEvents command to let windows run other jobs such as screenupdates.
Enjoy!

OK, thanks, I'll try that.

Is that the full syntax or is there much more to it?

Thanks, cheers . . . .

[Guus2005]

DoEvents is the complete command.

When your not sure try F1

HTH

[stellar0645]

OK, thanks. I looked up the syntax and tried it but no luck.

Apparently no events are triggered during Form Print - thanks MicroSoft.

Thanks, cheers . . . . .

[Jamy]

If you want to have multiple images, you'll need to create a report and open the on print screen, then use the code on detail level. Event: 'on format'.
The code is correct.

[stellar0645]

If you want to have multiple images, you'll need to create a report and open the on print screen, then use the code on detail level. Event: 'on format'.
The code is correct.

Thanks, I've got it figured now with much help (not from Microsoft).

You're basically correct, create a report with a line of code similar to the line that synchronizes the record and image in the form.

The good news is that a report can be created by cloning a form - Save As -> Report. Another hidden feature.

Thanks, cheers . . . . .