>>I have a public variable that I use to store my connection handle for SQL Passthrough. The variable is used in a number of forms, and was working fine until I came to a form that is telling me "Connection Handle is invalid."
>>
>>Why wouldn't the connection handle work for a particular form? I have checked to make sure that the variable does actually contain a valid handle, but for some reason, this one form won't use it. Can anyone explain this?
>>
>>Thanks!
>
>Is the form using a private data session? Just a WAG that this might cause a problem.
The form is using a private datasession, but so are all the other forms that actually work with the connection handle variable.