Thread: Chapter 15!!
View Single Post
  #17 (permalink)  
Old March 12th, 2004, 10:26 AM
Imar's Avatar
Imar Imar is offline
Wrox Author
Points: 72,055, Level: 100
Points: 72,055, Level: 100 Points: 72,055, Level: 100 Points: 72,055, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,086
Thanks: 80
Thanked 1,587 Times in 1,563 Posts
Default

Hi there,

The object rsItems is required. Take a look at this:

    rsItems.close
    Set rsItems = Nothing
Do While Not rsItems.EOF <--------------------

First you close the object, and then you set it to Nothing.
Nothing doesn't have an EOF property, so the code fails.
Don't close the Recordset until you're done with it.

Cheers,

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.