Parameter Object PROPERTY: Parameter::Direction ParameterDirectionEnum = parameterobject.Direction parameterobject.Direction = ParameterDirectionEnum   The Direction property is used to set or return a ParameterDirectionEnum constant that defines the direction of a Parameter object. By direction, we refer to how a Parameter is passed to or from a provider. This can be an input, output, input/output, or a returned value from a stored procedure.   You can also set the direction by using the CreateParameter method of the Command object. The default direction for this method is adParamInput.   ParameterDirectionEnum Constants Note that Microsoft Access does not recognize output parameters or returned values. Constant Value Description adParamInput 1 Input parameter adParamInputOutput 3 Both input and output parameter adParamOutput 2 Output parameter adParamReturnValue 4 Return value adParamUnknown 0 Direction is unknown   Code (VBScript): Set objParameter = Server.CreateObject("ADODB.Parameter") objParameter.Type = adInteger objParameter.Size = 3 objParameter.Direction = adParamInput objParameter.Value = intCount objCommand.Parameters.Append objParameter Copyright 1999-2001 by Infinite Software Solutions, Inc. All rights reserved. Trademark Information