Hello,
As I am very lost in this kind of request I'm asking you some help...
Thanks of this forum I'm able now to run a query with one parameter.
The code is:
This is runing fine for the query with only one parameter: [Status].
Now in this query I would like to add also a condition on an other field link to a combobox in the same Form.
It would be: Like ([Forms]![TA_CheckList_Preparation]![Combo_TypeOfTrade]) & "*"
But If I open the form again I get the message: "Too few parameters. Expected 2."
Could someone help me, please?
Thank you.
Michel.
As I am very lost in this kind of request I'm asking you some help...
Thanks of this forum I'm able now to run a query with one parameter.
The code is:
Code:
Dim dbs As DAO.Database
Dim qdf As DAO.QueryDef
Dim rst As DAO.Recordset
Set dbs = CurrentDb
'Get the parameter query
Set qdf = dbs.QueryDefs("Query_CheckListe_List")
'Supply the parameter value
qdf.Parameters("Status") = "Ready_For_Check_List"
'Open a Recordset based on the Query_CheckListe_List
Set Me.Recordset = qdf.OpenRecordset(dbOpenDynaset)
Me.Requery
This is runing fine for the query with only one parameter: [Status].
Now in this query I would like to add also a condition on an other field link to a combobox in the same Form.
It would be: Like ([Forms]![TA_CheckList_Preparation]![Combo_TypeOfTrade]) & "*"
But If I open the form again I get the message: "Too few parameters. Expected 2."
Could someone help me, please?
Thank you.
Michel.