ACC: Changes to Linked Object Do Not Update Source Properties

• Microsoft Access versions 7.0, 97

SYMPTOMS

If you change the source of a linked object on a form using the Links dialog box, the SourceDoc and SourceItem properties for that object are not updated although the object itself updates correctly.

CAUSE

The SourceDoc and SourceItem properties are not designed to reflect changes to an object's current source. These properties display their source when you create new objects. When you update existing objects through the user interface or programmatically through Visual Basic for Applications, the SourceDoc and SourceItem properties will not reflect the fact that the object has been changed to point to a file other than the original source.

MORE INFORMATION

Steps to Reproduce Behavior

1. Open the sample database Northwind.mdb and create a new form not based on any table or query.

2. On the Insert menu, click Object.

3. In the Insert Object dialog box, click Create From File.

4. Click the Browse button, click to select any bitmap file in the Windows main folder, and then click Open (or OK in Microsoft Access 7.0).

5. Click to select the Link check box, and then click OK.

6. On the Edit menu, click OLE/DDE Links.

7. Click to select the bitmap listed in the Links box and click the Change Source button.

8. In the Change Source dialog box, select a different bitmap file from the Windows main folder (a bitmap file other than the file you originally selected), and then click Open (or OK in Microsoft Access 7.0).

9. Click Close. Note that the linked object on the form is updated. When you view the object's properties, however, note that the SourceItem property is blank and that the SourceDoc property continues to point to the bitmap file that you originally selected.

REFERENCES

For more information about links, search the Help Index for "Linked Objects, Creating and Inserting," and then "Add a picture or other object to a form or report," or ask the Microsoft Access 97 Office Assistant.