I get the feeling this is illegal but I&#039;ll ask anyway. Can you query a result set in asp. I am using Access 2000 as my database and need to query a query. Example code (broken) <BR><BR>&#039; =-=-=-=-=-= building region array =-=-=-=-=-=-=<BR>RegIN = "SELECT DISTINCT "& series &".FipsCode, trim(FIPS.locality), FIPS.subregion FROM FIPS INNER JOIN "& series &" ON FIPS.FipsCode = "& series &".FipsCode WHERE "& series &".FipsCode IN ("& fip &") ORDER BY FIPS.subregion, "& series &".FipsCode;"<BR><BR>RegIN2 = "SELECT DISTINCT oReg.subregion, Subregion.regionname FROM Subregion INNER JOIN oReg ON Subregion.Subregion = oReg.subregion;"<BR><BR>Set oReg=Server.CreateObject("ADODB.RecordSet")<BR> oReg.Open RegIn, objConn, adOpenForwardOnly, adLockReadOnly, adCmdText<BR><BR>Set oReg2=Server.CreateObject("ADODB.RecordSet")<BR> oReg2.Open RegIn2, objConn, adOpenForwardOnly, adLockReadOnly, adCmdText<BR><BR>arrReg = oReg2.GetRows()<BR><BR>oReg.Close<BR>Set oReg = Nothing<BR><BR>oReg2.Close<BR>Set oReg2 = Nothing<BR><BR>rRecFirst = LBound(arrReg, 2)<BR>rRecLast = UBound(arrReg, 2)<BR>rFieldFirst = LBound(arrReg, 1)<BR>rFieldLast = UBound(arrReg, 1)<BR><BR>First query works. It is used elsewhere. Second query doesn&#039;t work because oreg can&#039;t be queried. The idea is that a table (series) containing data including locationids is queried against a location name table which has regionids.<BR><BR>Region table is then queried to present region names for a input statement on a form.<BR>I only want the regionids (unique) that are found valid(?) in series table so that only that choice is presented as a valid option.<BR><BR>Help?<BR><BR>Mark