Change properties in a Report from a Form

[WaltLukeIII]

I have an Image in a report, and I want to change the image in the report from a form. I have a drop down list of locaions of images to choose from. based upon the users choice I want to change the report. i.e. the properties ("Picture")
C:\image\image1 to C:\image\image2

Thanks



Walt III
SAElukewl@netscape.net

 

[Tranman]

If you want to have the form open when the report is created, you can change the picture in the "Print" Event of the report page.

Here's a snippet:
Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)

If Not IsNull(forms!myform!txtPic) Then
Image1.Visible = True
Image1.Picture = forms!myform!txtPic.text
Else
Image1.Visible = False
End If

Tranman

 

[WaltLukeIII]

Thanks for the Help I will have to try that i ended up making a query for the location of the image and then rerunning the query every time I change the image to be printed. A little more complicated probably but the best I could figure out. Thanks again

Walt III
SAElukewl@netscape.net