passing parameters into Access Query 1

[longshuen]

I have a parameter in a Query. How can I pass a value into it without having to type it in from a form?

Kind of like setting Bind Variables in Oracle SQL

Thanks
Andrew

 

[KenReay]

Hi

You can set it in code via the .parameter property of the query def

so using DAO syntax

Set Db = CurrentDb()
Set qdf = Db.QueryDefs("MyQuery&quot
qdf.parameters("MyParameter&quot = "MyValue" Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK