Displaying Embedded or Linked Data on Forms

You can enhance the design of forms by linking or embedding data such as Word documents or Microsoft Excel worksheets. Similarly, you can enhance reports by displaying linked or embedded data from General fields.

To link or embed data on a form

1. Create or open a form.

2. On the Form Controls toolbar, select the OLE Container Control button and drag to size on the form.

   The Insert Object dialog box appears, listing the types of files you can link or embed.

3. Create a new file by selecting Create New.

   -or-

   Use an existing file by selecting Create from File. Type the name of the file containing the data or choose Browse and select the appropriate file. Additionally, if you want to link to the file, select Link.

Changing or Breaking Links to Data on Forms

You change or break a link to data displayed on a form by using the Links command on the Edit menu.

To change a link to data on a form

1. Open the appropriate form.
2. Select the object whose link you want to change.
3. From the Edit menu, choose Links.
4. In the Links dialog box, choose Change Source.
5. In the Change Source dialog box, specify the new data source and choose OK.
6. In the Links dialog box, choose Close to complete the change.

To break a link to data on a form

1. Open the appropriate form.
2. Select the object whose link you want to break.
3. From the Edit menu, choose Links.
4. In the Links dialog box, choose Break Link.
5. Choose Close.

When the link is broken, the data becomes static.

See Also

Adding a General Field | Adding Reports and Labels | Changing or Breaking Links to Data in Tables | Displaying Embedded or Linked Data from Tables | Editing OLE Objects in Forms and Tables | Replacing Linked or Embedded Data with Static Data | Dynamic Information Sharing | Importing and Exporting Data | Adding OLE