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