Share via

ResyncCommand Property

  • Article

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.

Applies to | ElementExtension Object | RecordsetDef Object