I have 2 SQLs<BR>In the first SQL, the results are stored in recordset1.<BR>In the second SQL, I want to select the anwser from recordset1.<BR>This the SQLs I wrote:<BR>SQL1="SELECT Bus_No FROM Est_Bus WHERE Estate_ID=1"<BR>Results are stored in rs1<BR>SQL2="SELECT Sch_Bus FROM Sch_Bus WHERE Sch_Bus=&#039;" & rs1("Bus_No")&"&#039; AND School_ID=1"<BR>But it doesn&#039;t work.<BR>Can you give me a solution?<BR><BR>