ResyncCommand Property

Microsoft Office Web Components Object Model

ResyncCommand Property

       

Specifies an SQL command parameterized by the key field values from the specified recordset’s unique table such that the command returns exactly one record. The resync command is executed to "fix up" a row after an update or insertion is made. Read/write String.

expression.ResyncCommand

expression   Required. An expression that returns one of the objects in the Applies To list.

Remarks

You must set this property for any form based on a stored procedure that contains a join or expression column. In all other cases, Microsoft Access can fix tables automatically. If you do not set this property, users will not see fixed-up field values after an update or insertion, but the update or insertion will still be executed correctly.