Refresh the data in a linked picture or object

When you link to an object that was created in another application, Microsoft Access creates an automatic link by default. You can change the type of link to manual, or vice versa. This procedure only applies to linked pictures or objects in unbound object frames or bound object frames on a form or report. Background pictures and pictures in image controls are always updated automatically.

Note This type of link is different from a hyperlink that is used on a form or report to jump to another document, object, or page.

1. Do one of the following:
   • If the object is unbound, click the object in form or report Design view.
   • If the object is bound, open the form in Form view (or open a datasheet), find the record you want to change, and click the object.
2. On the Edit menu, click OLE/DDE Links.
3. In the Links box, click the link you want to update. To select multiple links, hold down the CTRL key while you click each link.
4. Do one of the following:
   • To refresh the data, click Update Now.
   • To specify that the data is refreshed whenever new information becomes available, click Automatic.
   • To specify that the data is refreshed only when you press SHIFT+F9 or click Update Now in the Links dialog box, click Manual. 

Note   When you make any changes to a link for a bound object frame, you are changing the link only for the current record. To make a change in a different record, move to that record and repeat the process.