I am getting two different runtime errors that I cannot figure out. I origionally didn't have the Rs.close in this code but I put it there hopeing to fix the error. But I have had no luck in trying to figure this out. I also tried the suggestions at MSDN, http://support.microsoft.com/default...b;en-us;275927, but that hasn't worked either.

Any suggestions?? Many thanks.

VB Code:
  1. 'change query to select all buildings

  2.         'Rs.Close

  3.         strsql = "select bldg from bldgtype where type = 1 order by bldg"

  4.         Rs.Open strsql, Db


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


VB Code:
  1. 'change query to select all buildings

  2.         Rs.Close

  3.         strsql = "select bldg from bldgtype where type = 1 order by bldg"

  4.         Rs.Open strsql, Db

Run-time error: '3704': Operation is not allowed when the object is closed.