QUERYDEF PARAMETER QUESTION

[trystanhuwwilliams1]

Hi,

I want to open a recordset based on a parameterized query with two parameters. This code works for opening a single parameterized query:

SET QDF = DB.QUERYDEFS("RECORDS QUERY")
QDF.PARAMETERS(0)=FORMS!STAFF!1STDATE
SET RST = QDF.OPENRECORDSET

How can I alter this code so that it includes another parameter?

Cheers

 

[muffingal]

hi,

When you set up the query that you are referring to in Access, you should place a parameter in criteria that you will refer to in the code. Once you have done that, you can assign variables to these parameters in the code. Example:

Set qdf = dbs.QueryDefs("Records Query&quot
qdf![LastNameParam] = Forms!staff!LastName
qdf![DateOfBirthParam] = Forms!staff!DateOfBirth
Set rst = qdf.OpenRecordset

I hope this helps. I am using code similar to this in one of my projects.

Good Luck!

 

[muffingal]

Hi again,

I think I may have misunderstood your problem. Check out

thread703-571214

Good Luck.