>>I thought I had the correct syntax to detect if a parameter has been passed.
>>
>>I have the following method which accept a parameter and I would like to know if the parameter was passed.
>>
>>Sub Cleanup(Optional tnError As Integer)
>>
>>' If we pass a parameter
>>If VarType(tnError) = 2 Then
>> lnLastError = tnError
>>End If
>>
>>But, this is not working because even if the tnError is not passed, the type is still integer.
>
>Couple things:
>
>1) Use the IsMissing() function in VB.
>2) Using IsMissing requries that your parameter be a variant.

This is working perfectly. Thanks.