Microsoft KB Archive/263738

= ACC2000: UniqueTable and ResyncCommand Properties Are Not Saved =

Article ID: 263738

Article Last Modified on 6/29/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q263738





Moderate: Requires basic macro, coding, and interoperability skills.

This article applies only to a Microsoft Access project (.adp).



SYMPTOMS
When you set the UniqueTable and ResyncCommand properties for a form and then view the form in Form view before you save the form, the settings for the properties are not saved.



RESOLUTION
Save the changes to the form in Design view before you switch to Form view.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.



Steps to Reproduce the Behavior
 Open the sample project NorthwindCS.adp.  In the Database window, click Stored Procedures under Objects, and then click New. Type the following stored procedure: Create Procedure CustOrders As SELECT Customers.CompanyName, Customers.ContactName, Customers.Address, Orders.* FROM Customers INNER JOIN Orders ON Customers.CustomerID = Orders.CustomerID  Close and save the stored procedure as CustOrders. In the Database window, click Forms under Objects, and then click New. In the New Form dialog box, click Design View, and then click OK.</li> If the property sheet is not displayed, click Properties on the View menu.</li> In the property sheet for the form, click the Data tab, and then set the RecordSource property to the CustOrders stored procedure.</li> If the field list is not displayed, click Field List on the View menu.</li> Drag all fields from the field list to the form.</li> In the property sheet for the form, click the Data tab, and then set the UniqueTable property to Orders.</li>  Type the following SQL statement in the ResyncCommand property: SELECT Customers.CompanyName, Customers.ContactName, Customers.Address, Orders.* FROM Customers INNER JOIN Orders ON Customers.CustomerID = Orders.CustomerID WHERE Orders.OrderID = ? </li> View the form in Form view.</li> Change the CustomerID field of the first record to a different, valid CustomerID (for example, WOLZA). Move to the next record in the form, and then move back to the record that you just modified. Verify that the resulting information appears correctly (that is, CompanyName, ContactName, and Address fields).</li> Close the form. When you are prompted to save the form, click Yes, and then click OK to save the form with the default name.</li> Open the form in Design view, and then view the property sheet for the form. Note that the UniqueTable and ResyncCommand properties are blank.</li></ol>

Additional query words: pra lost missing not there gone

Keywords: kbbug kbclientserver KB263738

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.