Link to home
Start Free TrialLog in
Avatar of kevinrea
kevinreaFlag for United States of America

asked on

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)
User generated image
thanks,
kevin rea
Lancaster, Calif.
Avatar of Jeffrey Coachman
Jeffrey Coachman
Flag of United States of America image

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
Avatar of kevinrea

ASKER

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
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
I would like to tie the current record selected in the sub form to
the picture embedded on the main form
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?
wow. you are kidding. what do you think it means ?
come on ...think !!
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
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
ASKER CERTIFIED SOLUTION
Avatar of Jeffrey Coachman
Jeffrey Coachman
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
very nice.. thank you very much Jeff.

any ideas for this one I have posted ?

https://www.experts-exchange.com/questions/28269300/combo-box-on-continuous-form-not-bringing-up-correct-record.html


Kevin
nice guy.
;-)

Thanks buddy

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

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

Jeff
ok.. what is mbizup ?  

kevin