Form opening from Picture Hyperlink 1

[BakerUSMC]

Hello to all,

I have a hyperlink to open a picture on an image control. I finally got it to work after numerous hours... But the problem is that once the hyperlink runs, it opens another form that contains part of the hyperlink.

location = filepath
Photo = file name
Picture = Image control

Private Sub Form_Current()

On Error Resume Next

    If Not (IsNull(Me!Photo)) Then
    Me![Image].Properties("Picture") = (Form_frmlocation!Location & Me!Photo)

    Else
    Me![Image].Properties("Picture") = ""
   
    End If
    
End Sub

I don't understand why it's opening frmlocation in the background. I hope I explained this clearly enough.

Hope someone can help!!!

Thanks,
BakerUSMC

 

[VBslammer]

This code is forcing it to load in hidden mode:
[tt]
= (Form_frmlocation!Location & Me!Photo)
[/tt]
If you only want to get the path if the form is already open, you can check for that:

If CurrentProject.AllForms("frmLocation").IsLoaded Then
  strPath = Forms!frmLocation!Location
End If

You can get the "Location" value from the table the form is bound to instead of using the form field. Try using one of the database functions, such as DLookup(). To find the Location field's value in the first record in the table use DFirst():

= DFirst("Location", "tblLocations") & Me!Photo

VBSlammer

"You just have to know which screws to turn." - Professor Bob

 

[BakerUSMC]

VBSlammer,

WOW, your post worked perfectly!! Thanks so much!!!

BakerUSMC