The information in this article applies to:
- Microsoft Access versions 2.0, 7.0, 97
SYMPTOMS
Novice: Requires knowledge of the user interface on single-user computers.
If you copy a record on a form in which one or more of the fields are
disabled or locked, the data in the disabled or locked fields is not copied
into the new record.
RESOLUTION
If you want to copy the entire record, be sure that the Enabled property is
set to Yes and the Locked property is set to No for all of the fields on
the form.
MORE INFORMATION
Steps to Reproduce Behavior
- Start Microsoft Access and open the sample database Northwind.mdb (or
NWIND.MDB if you are using version 2.0).
- In the Database window, click the Forms tab (or Form tab if you are
using version 2.0). Select the Suppliers form and click Design.
- Using the right mouse button (right click), click the Country text box,
and then click Properties on the shortcut menu.
- Click the Data tab, (or select Data Properties from the list at the top
of the property sheet if you are using version 2.0.). Change the Enabled
property of the Country text box to No.
- On the View menu, click Form View (or Form if you are using version
2.0). Using the record selectors at the bottom of the form, go to the
record you want to copy and note the total number of records.
- Use the following sequence of menu commands to copy the record:
a. On the Edit menu, click Select Record.
b. On the Edit menu, click Copy.
c. On the Edit menu, click Paste Append.
Note that the new record has no data in the Country field. If the
Country field in the new, copied record appears to contain a value,
press F9 to refresh the screen and view the actual data.
REFERENCES
For more information about the Enabled and Locked properties, search the
Help Index for "locking controls."
|