ACC2000: Data Not Copied to New Record If Control Is Not Enabled

ID: Q198457

The information in this article applies to:

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 controls are disabled or locked, the data in the disabled or locked control 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.


  2. In the Database Window under Objects, click Forms. Click the Suppliers form, and then click Design.


  3. If the property sheet is not displayed, right-click the Country text box, and then click Properties on the shortcut menu.


  4. Click the Data tab, and change the Enabled property of the Country text box to No.


  5. On the View menu, click Form View. Use the record selectors at the bottom of the form to go to the record that 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 Enabled and Locked properties, click Microsoft Access Help on the Help menu, type enabled and locked properties in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned. 


Keywords          : kbdta FmrHowto 
Version           : WINDOWS:2000
Platform          : WINDOWS 
Issue type        : kbprb

Last Reviewed: July 15, 1999