ACC: Data Not Copied to New Record If Control Is Not Enabled (174506)



The information in this article applies to:

  • Microsoft Access 2.0
  • Microsoft Access for Windows 95 7.0
  • Microsoft Access 97

This article was previously published under Q174506
Novice: Requires knowledge of the user interface on single-user computers.

SYMPTOMS

If you copy a record on a form in which one or more of the controls are disabled or locked, the data in the disabled or locked controls 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 the controls on the form.

MORE INFORMATION

Steps to Reproduce Behavior


  1. Start Microsoft Access and open the sample database Northwind.mdb (or NWIND.MDB if you are using version 2.0).
  2. 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.
  3. Using the right mouse button (right click), click the Country text box, and then click Properties on the shortcut menu.
  4. 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.
  5. On the View menu, click Form View (or Form if you are using version 2.0). Use the record selectors at the bottom of the form to go to the record you want to copy, and note the total number of records.
  6. To copy the record, follow these steps:

    1. On the Edit menu, click Select Record.
    2. On the Edit menu, click Copy.
    3. 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."

Modification Type:MajorLast Reviewed:5/9/2003
Keywords:kbprb KB174506