| Example object |
Type of control to use |
Inserted or linked? |
|---|---|---|
| A logo on an invoice report that you don't need to update | Image control | Inserted (if disk space isn't an issue; otherwise linked) |
| A picture on a form or report that you expect to update | Unbound object frame | Inserted |
| Part of a Microsoft Excel worksheet in a sales report | Unbound object frame | Linked |
| A picture for each employee to be stored in an Employees table | Bound object frame | Inserted |
| Employee résumés (created and stored in a Word document) available from an Employees form | Bound object frame | Linked, and displayed as an icon |
Microsoft Access automatically updates linked objects on a report when you preview or print it. It updates them on forms as shown in the following table.
| Object type | Property | Updated when |
|---|---|---|
| Unbound object frame | UpdateOptions: Automatic Locked: No |
The form is opened. |
| Bound object frame | UpdateOption: Automatic Enabled: Yes Locked: No |
The bound object frame gets the focus. |