How to: Display Embedded or Linked Data on Forms
You can enhance the design of forms by linking or embedding data such as Microsoft 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
Create or open a form.
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.
Choose one of the following:
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
Open the appropriate form.
Select the object whose link you want to change.
From the Edit menu, choose Links.
In the Links dialog box, choose Change Source.
In the Change Source dialog box, specify the new data source and choose OK.
In the Links dialog box, choose Close to complete the change.
To break a link to data on a form
Open the appropriate form.
Select the object whose link you want to break.
From the Edit menu, choose Links.
In the Links dialog box, choose Break Link.
Choose Close.
When the link is broken, the data becomes static.
See Also
Tasks
How to: Add General Fields to Reports
How to: Change or Break Links to Data in Tables
How to: Display Embedded or Linked Data from Tables
How to: Edit OLE Objects in Forms and Tables
How to: Replace Linked or Embedded Data with Static Data