SQL Loop Problem Run-time error '3705':

[chzwlkr]

hello! i'm just new in here.. I started practicing vba programming since yesterday... pls help me on my problem...

I've already connected my records at ms access.. the macro i made is only runnable at 1st row of my table.. so i made a loop to fill up the next rows with data..

but i got these error..

Run-time error '3705':
Operation is not allowed when the object is open

here's my code:
________________________________________

Please Login or Register  to view this content.

_________________________________________

I got the logic but i don't know how to code it properly..

still got many questions to ask.. but my priority was this one.. help me plz.. thanks in advance

[romperstomper]

You are trying to open the recordset repeatedly in your loop without closing it, or doing anything with it, and that makes no sense.
It's not clear to me whether you expect multiple records to be returned for each query that you do - if not, there is no need for the movenext; just open the recordset, output the values you want, close the recordset then loop.