Macros and SendKeys

[Guest]

I am running a macro which will open a report. This report is based on a
parameter query. Can I use the sendkeys function to respond within the macro
to the dialog box?

 

[tina]

suggest you avoid using the SendKeys action; it's not reliable. i assume the
dialog box you're referring to the criteria prompt from the parameter query?
if you "know" what criteria should be entered, just hard-code it in your
query. but if you need user input, you can put a control on a form for the
user to enter the value, and use that in the query's criteria, as

Forms!MyForm!MyControl

if you need another solution, please give some detail of how you were hoping
to use the SendKeys action to provide an appropriate query parameter.

hth