Macro will not paste

[JohnT]

Is there a way to get a macro to paste information copied from a form field in the parameter value window that the query will be based off of?

I am able to get the macro to navigate to the specified field and copy the contents, then opens the report which runs the query but stops at the parameter value window and does not paste the contents in. If I use ctrl+v, it does paste the information in and I can then press the ok button and have the report pop up. I want it to do this automatically and not require the user to enter the information themselves or have to push ctrl+v and then select the OK button.

Is this possible to do within Access itself or does this need to be performed via VBA?

Thank you for any feedback you can provide.

 

[ajetrumpet]

This is interesting. You cannot literally "paste" a value into a parameter box, but you can probably open the report up with the macro action and set a "open args" spec in the macro line itself. Do you think so? I wonder...