Parameter value in VBA

[Dharmesh]

Hi

I have a command button which is linked to a parameter query. The query runs perfectly when the command button is selected, but i want to add the value of the parameter query into the VBA code so that i dont have to keep on typing the value in. Is there a way of doing this.

Thanks

Dharmesh

 

[TjS]

Thanks to another thread (cannot remember exactly where i found it) http://mvps.org/access/queries/qry0003.htm describes the answer to your question

 

[chergh]

I usually do it as:

db.querydefs("queryname").parameters("param_name").value = value