G
Gary
I copy a cell from a excell worksheet (Card 1) and paste linked it into
Access 2k.
It created the unbound object frame with the following:
SourceDoc = c:\test\test.xls
Source Item = Card 1!Print_Area
I will have many worksheet from Card 1 to Card 99. After pasting it, I
wanted to change the Source Item = Card 2!Print_Area.
The worksheet Card 2 doesn't show up on my preview of the form. Card 1
shows up. I assume I could set the parameter SourceItem = "Card
2!Print_Area" in vba code and update the link. Would this allow me to select
different worksheet as the vba code is executed?? How do I get the picture
to update with the new link???
Thanks,
Gary
Access 2k.
It created the unbound object frame with the following:
SourceDoc = c:\test\test.xls
Source Item = Card 1!Print_Area
I will have many worksheet from Card 1 to Card 99. After pasting it, I
wanted to change the Source Item = Card 2!Print_Area.
The worksheet Card 2 doesn't show up on my preview of the form. Card 1
shows up. I assume I could set the parameter SourceItem = "Card
2!Print_Area" in vba code and update the link. Would this allow me to select
different worksheet as the vba code is executed?? How do I get the picture
to update with the new link???
Thanks,
Gary