Create a link on a form to part of an existing bound object

You can use this procedure if the application that you're linking to has OLE support for linking to part of an existing document.

1. If you haven't already done so, create a bound object frame on a form.

   How?

2. Switch to the application that you used to create the object and select the information you want to link. For example, open Microsoft Excel and select a range of cells.
   
   
3. On the Edit menu, click Copy.
   
   
4. Leave the application open, and switch back to Microsoft Access. Switch to Form view or Datasheet view, move to the record you want to paste the object into, and click the OLE Object field in a Microsoft Access database (.mdb), or the image column in a Microsoft Access project (.adp).
   
   
5. On the Edit menu, click Paste Special.
   
   
6. In the Paste Special dialog box, click Paste Link, and then click the type of object to paste as in the As list. For more information on these options, click .
   
   
7. Select the Display As Icon check box if you want the object to appear as an icon instead of as the object itself. Displaying an object as an icon can be helpful when an object contains supplementary information that doesn't have to be displayed. Displaying an object as an icon also uses significantly less disk space.
   
   
8. Click OK.

   If you're in Form view, then Microsoft Access displays the object. If you're in Datasheet view, then Microsoft Access displays the name of the object, for example "Microsoft Excel Worksheet."

9. If you need to edit the object, double-click it.

Notes

• You can adjust the size and proportions of the object after you paste it.

  How?

• You can also insert a bound object in a table or query datasheet. Just select the field that you want to insert the object into (it must be an OLE Object field or an image column), and click Paste Special on the Edit menu. Then follow steps 6 through 8 above. To see the object, you must create a bound object frame on a form or report.
  
  
• When you link an object, the link is automatic by default. Microsoft Access automatically updates the object when you move to the field. If you want to control when the link is updated, you can change the link from automatic to manual.

  How?