Results 1 to 9 of 9
  1. #1
    GraeagleBill's Avatar
    GraeagleBill is offline Experienced Old Geezer
    Windows 10 Access 2013 32bit
    Join Date
    Feb 2011
    Posts
    1,919

    Report Preview Hiddened


    I have a form with a combo from which user selects a print option.
    The event code:
    Code:
    Select Case Me.cboPrtOptions.Column(0)
        Case 1
            FilterExp = "PicID = " & Me.PicID
            DoCmd.OpenReport "rptBoxLabels", acViewPreview, , FilterExp
            
        Case 2
            DoCmd.OpenReport "rptBoxLabels", acViewPreview, , , , "AsSelected"
        
        Case 3
            DoCmd.OpenReport "rptBoxLabels", acViewPreview
    End Select
    For some reason I've not been able to determine, the preview does not come to the front but rather hidden behind the form containing the combo.
    What am I missing?
    Thanks,
    Bill



  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Hiddened?

    probably the form was opened with acDialog or has its popup/modal properties set.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Is your form a popup and has it been opened in dialog mode?
    Oops. I see Paul answered at the same time.
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Geez dude, go to bed!
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  5. #5
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    LOL. Good morning!
    Woke up at 3:00, answered Bill's question and soon after fell asleep again!
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  6. #6
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Good morning! You won't find me on the computer at 3am!!
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  7. #7
    GraeagleBill's Avatar
    GraeagleBill is offline Experienced Old Geezer
    Windows 10 Access 2013 32bit
    Join Date
    Feb 2011
    Posts
    1,919
    While you two were having your naps, I discovered I wasn't getting email notices that the thread had been updated with replies Anyway, I had already checked to see if the forms were popups but failed to check to see if the form with the combo box had been opened in Dialog, which it was. There was no compelling reason for Dialog mode so I suppressed that and now my print preview comes to the front as needed.
    Thanks,
    Bill

  8. #8
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    No problemo my friend.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  9. #9
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    You're welcome from me also ... and at a bit more civilised time than last night/this morning
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 4
    Last Post: 03-02-2018, 09:11 AM
  2. Report Preview
    By roaftech in forum Reports
    Replies: 3
    Last Post: 11-15-2012, 01:59 PM
  3. Report Preview
    By ColPat in forum Programming
    Replies: 2
    Last Post: 06-25-2010, 02:44 PM
  4. Can't see sub report in print preview
    By LoggyDoggy in forum Access
    Replies: 1
    Last Post: 04-20-2010, 05:38 PM
  5. Report preview from sub form
    By Hillary in forum Forms
    Replies: 2
    Last Post: 01-31-2010, 07:50 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums