[thelist] help: Object required

[James Hardy]

Dena wrote:

>  call subOpenDBConn()
>  dim conntemp
>
>  
>
after you define conntemp in the sub, you reinitialise it with the dim 
statement. Then when you try to use the object, it is not there.

swap the lines over and this error shouldn't occur

A bit confused about the line

conntemp.open oConn

my understanding is that where you have oConn, you should have a connectionstring rather than a connection object. This may cause errors as well. Not sure though.

-- 
James