Ok, Im a bit confused. Ive got a "Select * From Blah" as a stored procedure in SQL 7 (simplified, * is actually the short version of a whole lot of joins)<BR><BR>Now I can open this recordset / stored procedure as objRS.Open "Blah" and return ALL results, but I can not open it as objRS.Open "Select * from Blah where ...etc" to get a sub set of results.<BR><BR>I may have oversimplified it, but can someone point me to a resource with a sample code for exactly that or point out the common mistake?