ADO: ActiveX Data Objects

Name

Recordset.Requery Method — (Versions 2.0, 2.1, 2.5, 2.6)

Synopsis

                     recordset.Requery

Description

The Requery method of the Recordset object re-executes the command that created the recordset in the first place in order to cause a refresh of the recordset. This method has the same effect as calling the Close method followed by the Open method.

If you are adding a new record or editing an existing one, when you call the Requery method, an error is generated.

If you wish to change properties that are read-only while a Recordset object is open (CursorType, LockType, etc.), you must manually close and reopen the Recordset object by calling the Close method, editing the properties, and calling the Open method.

See Also

ExecuteOptionEnum