Applies To
Dynaset-Type Recordset Object, Recordset Object,Snapshot-Type Recordset Object,Table-Type Recordset Object.
Description
Returns a value that indicates whether a Recordset object supports the Requery method, which re-executes the query on which the Recordset object is based.
Return Values
The possible return values are:
Value
Description
True
The Recordset object supports the Requery method.
False
The Recordset object doesn't support the Requery method. Table-type Recordset objects always return False (0).
Remarks
Check the Restartable property before using the Requery method on a Recordset object. If the object's Restartable property is set to False, use the OpenRecordset method on the underlying QueryDef object to re-execute the query.
You can use the Requery method to update a Recordset object's underlying parameter query after the parameter values have been changed.
See Also
OpenRecordset Method, QueryDef Object, Requery Method.
Example
See the Requery property example.
Example (Microsoft Access)
See the Requery property example (Microsoft Access).