Showing larger image in form2 from form1

[rwahdan1978]

I have a form that is taking data from a query. One of the fields have a tring that holds the location (path) of image. some records have image and some don't. I can see the correct image in form1 but when clicking on it, it is going to form2 to show a large size of the same image sometimes it is right and sometimes it is the wrong image?

form1 code:

Private Sub Image64_Click()
    DoCmd.OpenForm "form2"
End Sub

form2 code:

Private Sub Form_Load()
    Me.Image0.Picture = Forms!Form1!Image64.Picture
End Sub

[CJ_London]

I presume your first form is a continuous form. Image controls cannot receive the focus to set the selected record to current so your second form will be picking up whatever happens to be current.

solution - overlay your image control in the first form with a transparent text box or button and apply your code to that control instead

[señor_sriracha]

Here is a pair of articles about using a Conc() (concatenate) and Parse() function (source code included in the articles) to pass information to a form/report using the OpenArgs argument of the DoCmd.OpenForm/Report function. You could use this method to pass the path/name of the image file from form1 to form2, then parse it out and display it.

https://nolongerset.com/part-and-parse-l/
https://nolongerset.com/come-together/