Object close

  • Thread starter Thread starter kheav_samang
  • Start date Start date
K

kheav_samang

Please help me ! i have a problem with recordset loop

when I loop on one recordset, there was an error message
Operation can not access, object closed.

Could you please help me in this case ?
 
How about a little more information?

1 - The *exact* error message and the line that it's happening on.

2 - Copy and paste the section of code with the loop in it into a message. (Do *not* attach an mdb file.)

If I had to make a wild guess, I'd say you're not testing for the recordset end-of-file flag and handling it properly.

--

Sco

M.L. "Sco" Scofield, MCSD, MCP, MSS, Access MVP, A+
Useful Metric Conversion #15 of 19: 5 dialogues = 1 decalogue
Miscellaneous Access and VB "stuff" at www.ScoBiz.com
 
Back
Top