Microsoft KB Archive/174506

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

Article ID: 174506

Article Last Modified on 1/20/2007

-

APPLIES TO


 * Microsoft Access 2.0 Standard Edition
 * Microsoft Access 95 Standard Edition
 * Microsoft Access 97 Standard Edition

-



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.



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). 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. 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.</li></ol>

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>

<div class="references_section">