odbc query recordset reference

[Guest]

Hello all,
I'm tring to setup an application that will send Mutiple people an email
from a form. I have followed some of the other post to this forum, but none
seem to work for me. I think my Problem is my tables or all ODBC
connections. When I try to set a reference to my query recordset so I can
loop thru them to make the list of address to send to:. I get this error
Run-time error '3061': too few Parameters.Expected 2.
Here is the Set command
Set rst = CurrentDB.QueryDefs("managers").OpenRecordset
If I import the table it will work correctly, but fails if I leave the table
linked via ODBC.

Basically How do set a recordset to a query of a linked table?

thanks
john

 

[Guest]

I found the Problem! It was a parameter issue not ODBC. here is a link to
the fix.
http://www.microsoft.com/office/com...8ada&catlist=&dglist=&ptlist=&exp=&sloc=en-us