Move Method

Moves the pointer in the desired direction upon the result of the query.

Applies to objects: Recordset.

Syntax

[[Let] RetVal = ] object.Move([Step], [Start])

The Move method syntax has these parts:

Part Description
object Required. A reference to an instance of the object.
RetVal Optional. A Boolean type variable, that indicates whether the pointer was moved to the necessary string.
Step Optional. A Long type variable, indicates the number of strings to move by.
Start Optional. A Long type variable, indicates the string number to move to.

Remarks

If Start is not defined or equals 0, the pointer will be moved relative to the current string. The ability of the pointer to move in such way is determined with the help of the CanMove method with the cdbMoveRelative parameter.

If the Start and Step parameters are not defined or equal 0, the pointer will be moved one string forward. The ability of the pointer to move in such way is determined with the help of the CanMove method with the cdbMoveNext parameter.

If the Start is defined and not equal to 0, the pointer will be moved to the string described as Start + Step. The ability of the pointer to move in such way is determined with the help of the CanMove method with the cdbMoveAbsolute parameter.

The Step parameter can take positive or negative values.

Example

.......

 

See Also

Recordset Object, CanMove Method, MoveFirst Method, MoveLast Method, MoveNext Method, MovePrevious Method.