Unbound Object Frame

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top