Hello all
after get the results of one select in database,access using CurrentProject.Connection , I close everything , RecordSet and Connection, and then I want to make other select,to other table, and i got an infinite cycle...i saw that in EOF property i have "Operation is not allowed when the object is closed" ....when before that i write "RecordSetName.Open sss,conDatabase, adOpenDynamic, adLockOptimistic" like in my first access ??????
can anybody help me???
t.y.
after get the results of one select in database,access using CurrentProject.Connection , I close everything , RecordSet and Connection, and then I want to make other select,to other table, and i got an infinite cycle...i saw that in EOF property i have "Operation is not allowed when the object is closed" ....when before that i write "RecordSetName.Open sss,conDatabase, adOpenDynamic, adLockOptimistic" like in my first access ??????
can anybody help me???
t.y.
