Unanswered: "Set Focus" to Report Open in the Background
I have a report that is opened acViewPreview, and I have set focus to another form after it is opened for reasons relating to a process that I am trying to accomplish. Does anyone out there know how to "Set Focus" back on that report that is opened in the background? I have tried just issuing another docmd.openreport for that report but I have had a strange result happen in that Access opened another instance of the report. I have considered just closing the report and reopening it, but I didn't want to make the user wait for it to reopen. I am using Access 2003. Man, I am wishing for the .net show() command. I thank you in advance for your replies and your time.