Microsoft KB Archive/198457

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

Article ID: 198457

Article Last Modified on 6/24/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q198457





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.



Steps to Reproduce Behavior
 Start Microsoft Access, and open the sample database Northwind.mdb. In the Database Window under Objects, click Forms. Click the Suppliers form, and then click Design. If the property sheet is not displayed, right-click the Country text box, and then click Properties on the shortcut menu. Click the Data tab, and change the Enabled property of the Country text box to No. 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. To copy the record, follow these steps: <ol style="list-style-type: lower-alpha;"> On the Edit menu, click Select Record.</li> On the Edit menu, click Copy.</li> 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.</li></ol> </li></ol>

<div class="references_section">