"Too few parameters" error - sometimes

P

PayeDoc

Hello All

I'm getting a "Too few parameters" error - sometimes - on the following:

Set rstS = CurrentDb.OpenRecordset("select * from [qry bulletin
recipients]")

The odd thing is that, when [qry bulletin recipients] is:

SELECT practices.email, practices.[prac mgr calling name], practices.[prac
name], practices.[20056 EOY]
FROM practices
WHERE (((practices.email)="[email protected]"));

.... there's no error, but when I amend the query to:

SELECT practices.email, practices.[prac mgr calling name], practices.[prac
name], practices.[20056 EOY]
FROM practices INNER JOIN [qry eoy stages] ON practices.[prac name] = [qry
eoy stages].[prac name]
WHERE (((practices.[20056 EOY])="1"));

.... I get the error. Nothing else is changed.

How can this be?

Hope someone can enlighten me.
Many thanks
Les
 
G

ghetto_banjo

does the query [qry eoy stages] have any parameters? if so, those
parameters need to be resolved first before you open a recordset on
it.
 
Top