I am trying to insert pictures into a report based on which ones the user selects.
When the options form is opened, the correct file is also opened showing the pictures that the user has to choose from. The form has several toggle buttons (1-20) that they will switch on to select which 4 pictures they want to appear on the report. Here is where my problem starts.
In the "On Open" property of the report, I put in the following code, hoping that the image frame would know how to handle it;
Private Sub Report_Open(Cancel As Integer)
If Forms!IncPopup!Tog1 = -1 Then
Me.Pic1 = "T:\PG Operations\Accident, Incident, Injury Reporting\Accident Folders\01.jpg"
End If
End Sub
If this worked, I would have gone on to add IF statements for the other toggle buttons & jpg's.
I tried this with images, bound object frames & unbound object frames to the report, but can't get any of them to work the way I want. If I use an Image, I get the following error;
Run Time Error '438': Object doesn't support this property or method
If I use a bound object frame, I get this error;
Run Time Error '2147352567 (80020009)' You can't assign a value to this object.
I'm not good with coding (obviously), and often wonder how I got this far in Access. Can anyone set this derailed train onto the right track to making this work?