function error

[ajaym83]

1. i hav one modul in which only connection open and connection close sub esist. both are public defined
2. i have some private sub fun() in my main frm application
prob: when i execute the application connection is opened when form loads.
it is working properly
but when i invoke some private sub like filllist() , fillcombo
it generates an error message below:
operation is not allows\ed when the object is opened
run time error:3705

[lotus18]

1. i hav one modul in which only connection open and connection close sub esist. both are public defined
2. i have some private sub fun() in my main frm application
prob: when i execute the application connection is opened when form loads.
it is working properly
but when i invoke some private sub like filllist() , fillcombo
it generates an error message below:
operation is not allows\ed when the object is opened
run time error:3705

As I understand, when you open an object you need to close it.
[CODE=vb]ObjectName.Clos e[/CODE]

You can post some of your codes here for the reference of our experts here.

[debasisdas]

It seems you are trying to open the connection again while the connection is still opened.

Always check for connection state before opening the connection..

[ajaym83]

how can i resolve it

[QVeen72]

Hi,

Close the Recordset before Opening it and after you are finished using it.....

Set RST = Nothing
RST.Open .....
'Close it after usage
RST.Close


REgards
Veena

[Killer42]

I think it would help if you could show us the exact statement which generates the error.