Results 1 to 2 of 2
  1. #1
    fluffyvampirekitten is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Jun 2015
    Posts
    108

    BrowseTo isnt available now HELP!

    I have form"frmUploadPEUS" with the button "cmdAnalyze". I was trying to do is to click this button and I want to open up another form"frmMain" which has Navigation tab ; that display a subform called "frmPEUS"

    However, i keep getting this error "BrowseTo isnt available now"

    Can i anyone help me?
    pulling my hair to find a solution .
    Thanks in advance



    Code:
    Private Sub cmdAnalyze_Click()
    On Error GoTo cmdAnalyze_Click_Err
    DoCmd.Close acForm, "frmUploadPEUS"
    DoCmd.BrowseTo acBrowseToForm, "frmDuplicatePEUSDS", "frmMain.NavigationSubform>frmPEUS.DS", "", "", acFormEdit
    cmdAnalyze_Click_Exit:
        Exit Sub
    cmdAnalyze_Click_Err:
        MsgBox Error$
        Resume cmdAnalyze_Click_Exit
        
    End Sub

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,632
    Why using BrowseTo? I have never used this command. Why not just OpenForm?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Key isnt unique
    By lithium in forum Programming
    Replies: 1
    Last Post: 11-17-2014, 08:59 PM
  2. Replies: 8
    Last Post: 06-19-2014, 04:20 PM
  3. BrowseTo and DataEntry on navigation form
    By Daimios in forum Forms
    Replies: 3
    Last Post: 06-05-2014, 07:31 AM
  4. Macro Search Form : BrowseTo
    By char in forum Access
    Replies: 0
    Last Post: 11-19-2012, 04:41 PM
  5. Can anyone see why this isnt working please?
    By shabbaranks in forum Programming
    Replies: 3
    Last Post: 12-23-2011, 03:19 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