kevinrea
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)
thanks,
kevin rea
Lancaster, Calif.
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)
thanks,
kevin rea
Lancaster, Calif.
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
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
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
ASKER
I would like to tie the current record selected in the sub form to
the picture embedded on the main form
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?
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?
ASKER
wow. you are kidding. what do you think it means ?
come on ...think !!
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
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
ASKER
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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
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
ASKER
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
Thanks buddy
In your other Q, I think mbizup can get you sorted.
If not, ...then post another comment there to "tickle" me.
Jeff
ASKER
ok.. what is mbizup ?
kevin
kevin
:-)
...sorry, ...mbizup is the expert who is helping you in your other question...
https://www.experts-exchange.com/questions/28269300/combo-box-on-continuous-form-not-bringing-up-correct-record.html?anchorAnswerId=39579267#a39579267
...sorry, ...mbizup is the expert who is helping you in your other question...
https://www.experts-exchange.com/questions/28269300/combo-box-on-continuous-form-not-bringing-up-correct-record.html?anchorAnswerId=39579267#a39579267
Please review the sample carefully and try to adapt it to your situation.
If you have any questions, ...let me know.
Access-BasicLinkFormReportImages.mdb