Hi,
I have a Access application which has following code.
Set qry = CurrentDb.QueryDefs("qrySumOfExpenses")
qry.Parameters("param1") = pubLocation
Set rec = qry.OpenRecordset
The above code is giving the error 3001: Invalid argument in the above query.
But when I run the query manually in Access DB, it is running fine, I is asking for the parameter and once I entered the parameter, it showing the result well. But in code, it is showing the error.