Running parameter query with variable value

[RichyT]

I wish to run a parameter query from a macro, so that the parameter is passed in from a variable within the macro. Could anyone please help?

Cheers

Rich

 

[xlbo]

If you are running an MSquery, I think you will need to extract the SQL staement and build it freehand within the code 'cos if not, all the fields / parameters / criteria etc are contained within the dqy file and therefore not referenced in the macro itself
HTH
Geoff

 

[RichyT]

If I do this, will I have to use the 'DoCmd.RunSQL' syntax, and if so, how do I pass the parameter into the string?

 

[xlbo]

Aaaaaaaah - sorry - thought you were in excel. Much easier in Access. If the parameter is to be driven by an entry on a form just use formname.controlname.value in the criteria pane in the query and then just run the query as normal.
It very much depends on how you are getting your parameter variable tho
Rgds
Geoff