Linked Image Load error on form?? (Application.Path) via combo selection

[djspod]

Hi,



I'm really scratching my head with this one, what I am I doing wrong!

I have actually achieved this a while ago with another DB, copied all the settings to the new DB and I can't get it to work?



Any help I would be very grateful.

Thanks

Darren

[djspod]

Hi,

I'm really scratching my head with this one, what I am I doing wrong!

I have actually achieved this a while ago with another DB, copied all the settings to the new DB and I can't get it to work?



Any help I would be very grateful.

Thanks

Darren

https://warburtons-my.sharepoint.com...IkA9hQRIZyP_nY


https://warburtons-my.sharepoint.com...C-N1W-Kxi5n7IM

[AccessPower]

Try creating a Form Load event and leave it blank, on the main form/subform.

[djspod]

DB File and a small selection of image samples are available via the links posted above.

I store the images in a folder called Images within the same folder as the database.

Thanks

Darren

[ranman256]

Sometimes the ON LOAD event is not the error. If there is no code in that Event, then its usu a hard coded property setting.
do you have an image path set in a property?
does the query pull images from the table?

[djspod]

Option Compare Database
Private Sub cboLineNo_Change()
Me.Image241.Picture = Me.cboLineCode.Column(4)
End Sub
 
Private Sub Form_Load()
End Sub
'Private Sub Form_Load()
'Me.Image241.Picture = Me.cboLineCode.Column(4)
'End Sub

Just tried that and commented the original on load event out and inserted a blank onload

parameter box pops up 'application.currentproject.path' ?

[djspod]

Yes it does, In the Combo box LineCode query

Image: [Application].[CurrentProject].[path] & "\Images" & [PhotoLoc]

Am I doubling up on the code to mess it up, query and vba?

[djspod]

Finally cracked this, I was missing the Control source for image
cboLineNo [Column2]

Thanks everyone for the input