How to tie picture in main for to record in sub form

Hi guys,
I have a main form with a sub form.
pretty basic.
I would like to to the current record selected in the sub form to
the picture embedded on the main form.
any ideas ?
I am using Access 2010.
the subform records are connected to the main form by the field   customercounter
I have included a picture of my form(s)
Picture of Main Form with Sub Form
thanks,
kevin rea
Lancaster, Calif.
kevinreaAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jeffrey CoachmanMIS LiasonCommented:
try this:

Please review the sample carefully and try to adapt it to your situation.
If you have any questions, ...let me know.
Access-BasicLinkFormReportImages.mdb
0
kevinreaAuthor Commented:
thanks for the sample, but as far as I can see that is just a standard single form with an image.
I know how to do that already.

kevin
0
Jeffrey CoachmanMIS LiasonCommented:
OK, sorry about that.

Then what, exactly, is it you are wanting to do?
This is unclear:
<I would like to to the current record selected in the sub form to
the picture embedded on the main form.>

...I see that the image also has a path, so I presumed the image was linked, ...not embedded...


Or simply post a clear graphical example of what you need, or want the form to look like.

Thanks

JeffCoachman
0
Newly released Acronis True Image 2019

In announcing the release of the 15th Anniversary Edition of Acronis True Image 2019, the company revealed that its artificial intelligence-based anti-ransomware technology – stopped more than 200,000 ransomware attacks on 150,000 customers last year.

kevinreaAuthor Commented:
I would like to tie the current record selected in the sub form to
the picture embedded on the main form
0
Jeffrey CoachmanMIS LiasonCommented:
Again, I am not understanding what "Tie to" means

Lets use basic terminology...
Is you goal here to have an image for each subform record.
Then when you select a record in the subform, you want that specific image to appear on the main form?
Yes or No?
0
kevinreaAuthor Commented:
wow. you are kidding. what do you think it means ?
come on ...think !!
0
Jeffrey CoachmanMIS LiasonCommented:
There are literally half a dozen way this could have been interpreted, so I was just making sure...
As a Sr PC Computer Technician, I am sure you know the values of having a clear understanding of the issue...

So, ...insults aside, ("come on ...think !!")
...do you still want my help in resolving this?

JeffCoachman
0
kevinreaAuthor Commented:
not insults.., just direct questions.
I am also a senior PC Tech, for Northrop Grumman in Redondo Beach, Calif.
big deal.
when a field is tied to another element, it means that when you select the record in the subform, that the picture is tied to that record and changes accordingly.
ie...the record in the subform says the vessel name:  destiny, so the picture on the main for would change to the picture of the vessel desiny.
If the record in the subform is pointing to the record of the vessel named: Odyssey, then the picture on the main form would change to the picture of the vessel Odyssey.
not insults.. just trying to get you to think outside of your own box.
something as PC techs, we , at least my team, has to do every day.
kevin
0
Jeffrey CoachmanMIS LiasonCommented:
Then the subform record should contain the Full path and full fileneme reference to the image, in a field:
ex:
Field name:  ImagePath
Control Name: txtImagePath
The Controlsource will be something like: c:\YourFolder\YourImage.jpg" (different for each subform record, obviously)
Then you would insert an image control in the main form to display the image. (Name it something like: "YourImageControl")
Then on the current even of the subform add code like this to display the image on the main form:

    Me.Parent.YourImageControl.Picture = Nz(Me.txtImagePath, "")

;-)

<not insults.. just trying to get you to think outside of your own box>
I have spent 10 years here, and answered over 5,000 question, so like you, thinking outside the box is something I do on a regular basis.
http://www.experts-exchange.com/M_2293853.html

;-)
image for record1Image for record 2
JeffCoachman
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
kevinreaAuthor Commented:
very nice.. thank you very much Jeff.

any ideas for this one I have posted ?

http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_28269300.html


Kevin
0
kevinreaAuthor Commented:
nice guy.
0
Jeffrey CoachmanMIS LiasonCommented:
;-)

Thanks buddy

In your other Q, I think mbizup can get you sorted.

If not, ...then post another comment there to "tickle" me.

Jeff
0
kevinreaAuthor Commented:
ok.. what is mbizup ?  

kevin
0
Jeffrey CoachmanMIS LiasonCommented:
:-)
...sorry, ...mbizup is the expert who is helping you in your other question...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_28269300.html#a39579267
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.