June 2001
Intermediate to advanced
620 pages
19h 29m
English
Recordset.Requery Method — (Versions 2.0, 2.1, 2.5, 2.6)
recordset.RequeryThe 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.
ExecuteOptionEnum
Read now
Unlock full access