ACC2000: Unbound OLE Object Frame on Report Is Not Updated (202174)


The information in this article applies to:

  • Microsoft Access 2000
This article was previously published under Q202174
Novice: Requires knowledge of the user interface on single-user computers.


This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).

SYMPTOMS

When you have an unbound object frame that has a linked object on a report, changes in the data or content to the source object are not displayed in the report.

RESOLUTION

Add the unbound object frame to a form first, set its Enabled property to Yes and its Locked property to No, and then embed the form on the report. This makes any changes that are made to the source object appear immediately in the report.

To see an example of this workaround, follow these steps:
  1. Start Microsoft Excel, and then open a new workbook.
  2. In cells A1:A3, type the numbers 1, 2, and 3, respectively.
  3. Save the workbook as Book1.xls, and then close it, but leave Microsoft Excel open.
  4. Open a new database in Microsoft Access.
  5. Create a form, but do not base it on any table or query.
  6. Add an unbound object frame to the detail section of the form.
  7. In the Insert Object dialog box, click Create From File, click to select the Link check box, and then click Browse.
  8. In the Browse dialog box, click Book1.xls, and then click OK.
  9. In the Insert Object dialog box, click OK.
  10. On the View menu, click Properties, and then click the Data tab.
  11. Change the Enabled property to Yes and the Locked property to No.
  12. Save the form as frmLinkFix, and then close it.
  13. Create a new report, but do not base it on any table or query.
  14. On the Windows menu, click Tile Vertically.
  15. In the Database window, click Forms, and then drag the frmLinkFix form to the report. Note that the form is now a subform on the report.
  16. On the Windows menu, click Cascade.
  17. Save the report as rptLinkFix, and then close it.
  18. In Microsoft Excel, open Book1.xls, and then change the values in cells A1:A3 to 4, 5, and 6, respectively.
  19. Save and close the workbook.
  20. Open the rptLinkFix report in Print Preview. Note that the three values in the object frame match those currently in the workbook.

MORE INFORMATION

After each change to the source document, open the report in Design view first, and then switch to Print Preview. Then, the data or content of the source document is displayed correctly.

Steps to Reproduce the Behavior

  1. Follow the first four steps of the "Resolution" section earlier in this article.
  2. Create a new report, but do not base it on any table or query.
  3. Add an unbound object frame to the report.
  4. In the Insert Object dialog box, click Create From File, click to select the Link check box, and then click Browse.
  5. In the Browse dialog box, click Book1.xls, and then click OK.
  6. In the Insert Object dialog box, click OK.
  7. Switch to Print Preview and note that the three values in the object frame match the data that you entered in the workbook.
  8. Save and close the report as rptLinkTest.
  9. Open Book1.xls in Microsoft Excel, and change the values in cells A1:A3 to 4, 5, and 6, respectively.
  10. Save and close the workbook, but leave Microsoft Excel open.
  11. Open the rptLinkTest report in Print Preview. Note that the three values in the object frame do not match those that currently exist in the workbook.
  12. Switch to Design View and immediately back to Print Preview. Note that the values in the unbound object frame now match those in the workbook.
Modification Type:MajorLast Reviewed:6/24/2004
Keywords:kbprb KB202174
©2004 Microsoft Corporation. All rights reserved.