Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2002
    Posts
    154

    Question 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.

  2. #2
    Join Date
    Feb 2004
    Location
    Chicago, IL
    Posts
    1,312
    Does this work for you?

    Application.DoCmd.SelectObject acReport, "YourReportName"

  3. #3
    Join Date
    Nov 2002
    Posts
    154
    That's awesome! Thanks DC, I knew that there had to be a method out there for doing that.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •