Hi,

I have a query with three fields that have criteria set to fields on a
form. The form is open and those fields have the proper data entered
in them. But when trying to set a recordset to that query (Set
rstResourcesScheduled_pw =
dbCurr_pw.OpenRecordset("qryResourceCalendar")), I get the "too few
parameters, expected three".

I thought this would be easier than having to filter the recordset
when reading through it.

I guess Access (2003) doesn't like what I am doing?

-paulw

You need to explicitly resolve the parameters.

Dim qdf As DAO.QueryDef
Dim prm As DAO.Parameter

Set qdf = dbCurr_pw.QueryDefs("qryResourceCalendar")
For Each prm In qdf.Parameters
prm.Value = Eval(prm.Name)
Next prm
Set rstResourcesScheduled_pw = qdf.OpenRecordset



--
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/djsteele
Co-author: "Access 2010 Solutions", published by Wiley
(no e-mails, please!)



"PW" <emailaddyinsig (AT) ifIremember (DOT) com> wrote

On Fri, 1 Oct 2010 16:50:43 -0400, "Douglas J. Steele"
<NOSPAM_djsteele (AT) NOSPAM_gmail (DOT) com> wrote:


I've never done that before Douglas! Something new! Nice!

I think it's working but I have to get through some other bugs.

Very good!

-paul

On Fri, 1 Oct 2010 16:50:43 -0400, "Douglas J. Steele"
<NOSPAM_djsteele (AT) NOSPAM_gmail (DOT) com> wrote:


Thanks for the lesson! Works great!

-paul