Inserting an dynamic image into a form

[Phillip2]

I have a command button (ADD / EDIT) that looks at my customer's record number (TBrecord.value). If there isn't a number it assigns one, otherwise it edits the existing record.
The second page of my userform contains a picture insert. I'm wanting to change this picture to a jpg image of a call tree diagram. These images are stored in a folder titled Images and are named with the customer's record number 001, 002, 003 etc. (TBrecord.value).

I am trying to come up with a macro that I can add inside of my sub that will use the customer's record number (TBrecord.value) and insert it inside of the image's address when this sub is used.

CallTree.Picture = Load Picture ("Y:\CCX Applications\") & ("TBrecord.jpg")

Thanks in advance. I appreciate any help.

 

[RoryA]

Please take a moment to re-read the forum rules on cross-posting and then follow them. (they are the same as at the other forum where you have posted this, also without links). Thanks.

 

[Phillip2]

Thanks RoryA. Here is the cross posting link.

 

[RoryA]

Thanks. The code is basically:

CallTree.Picture = LoadPicture("Y:\CCX Applications\" & TBrecord.Text & ".jpg")

 

[Phillip2]

Thanks Rory that's what I needed. I really appreciate it.