I have a form where the user select a report to run and then clicks a command button which calls a macro.

The macro opens a report in print preview and then uses send keys to select primter and print. The macro works fine but here is the odd thing.

The first time your open the form and click on the run report button, the report opens and print preview only? If you close the report and run again, the send keys work?

Did I miss something here?

thanks!

From what I've gleaned by several posts by some, even more senior members on the forum, is that send keys when used in Access are not necessarily reliable and can yield different results from time-to-time depending on what it is they are doing.

It's best to avoid SendKeys if possible and use other commands, unless you absolutely have no commands available to you.

this is all I know how to do

I have it select my pdf coverter and then user had to type .pdf name