how do i base one select statement on another

[jacq]

i have created a 1st page and requested the fields, namely pname and parea, on the 2nd page. all but one of the fields are in tblproject, the other's in tblname. i need to say:
"select name from tblname where area = parea", set rs etc, and then
"select * from tblprojects where name = rs(area)...i tried to 'do while not rs.eof' and it gets stuck in a loop
i tried this:
sqlstmt = "Select * from tblproject WHERE '" & pname & "%' In (SELECT name FROM tblname WHERE area= '" & parea & "'), but it says 'Unterminated string constant'

 

[Geee]

There is a " missing after the last )

G -GTM Solutions, Home of USITE-
-=

http://www.gtmsolutions.com=-

 

[Tinman]

sqlstmt = "Select * from tblproject WHERE '" & pname & "%' In (SELECT name FROM tblname WHERE area = '" & parea & "')"
Chad
tinman@thelandofoz.org

Tinman,

Welcome to OZ.

 

[jacq]

thanks
it was the double quote...but also the % in the pname which was adding on to then name and so the database couldn't find a match

sqlstmt = "Select * from tblproject WHERE '" & pname & "%' In
(SELECT name FROM tblname WHERE area = '" & parea & "')"