Microsoft Office Tutorials and References
In Depth Information
After opening the Object Dependencies pane
object that serves as
the basis for the
Object Dependencies list box
warning messages and help
Trouble? If the “Objects that depend on me” option button is not selected, click
the option button to select it.
The Object Dependencies list box displays the objects that depend on the
tblCustomer table, the object name that appears at the top of the pane. If you
change the design of the tblCustomer table, the change might affect objects in the
list box. Changing a property for a field in the tblCustomer table that’s also used
by another listed object affects that other object. If the other object does not use
the field you are changing, that other object is not affected.
Objects listed in the Ignored Objects portion of the pane might, or might not, have
an object dependency with the tblCustomer table, and you’d have to review them
yourself. The Help section at the bottom of the pane displays links for further infor-
mation about object dependencies.
2. Click the frmCustomer link in the Object Dependencies pane. The frmCustomer
form opens in Design view. All the fields in the form are fields from the
tblCustomer table, which is why the form has an object dependency with the table.
3. Switch to Form view for the frmCustomer form. Note that the Phone field values
are displayed using the input mask you applied to the field in the tblCustomer
table. This change propagated from the table to the form.
4. Close the frmCustomer form, open the tblContract table in Datasheet view, and
then click the Refresh link near the top of the Object Dependencies pane. The
Object Dependencies list box now displays the objects that depend on the
5. Click the Objects that I depend on option button near the top of the pane to
view the objects that affect the tblContract table.