[dba-SQLServer] Moving some object's recordsource to SQL Server

On 26 Jan 2006 at 14:47, Stuart McLachlan wrote:

> Set qry.SQL = "select * from mytable where id = " & cboIDSelector

Oops, that line is totally screwed up.

It should be:
qry.SQL = "sp_MyStoredProcedure " & cboIDSelector

i.e.  no "Set" and the SQL is the SP call




-- 
Stuart