DoCmd.OpenForm does not work

jansb000 · March 24th, 2008, 12:45 PM

Hi,

I created a form that contains a button (MS Access 2007). With this button I want to open a second form. Unfortunately the second form does not open. Nasty detail: The button (and the code below) are generated by the button-wizard.

Code:

Private Sub Knop111_Click()
On Error GoTo Err_Knop111_Click

    Dim stDocName As String
    Dim stLinkCriteria As String

    stDocName = "Adres_Bewerken"
    DoCmd.OpenForm stDocName, , , stLinkCriteria

Exit_Knop111_Click:
    Exit Sub

Err_Knop111_Click:
    MsgBox Err.Description
    Resume Exit_Knop111_Click

End Sub

Any clues?

mmcdonal · March 25th, 2008, 06:45 AM

I would look at whether the form was open and behind the first form (which your code indicates is not closed when the new one opens). I would also look at the second form to see if there was some code the prevented it from being shown. Also, does it need to be a Pop-Up form? I don't like Access 2007.

mmcdonal

Look it up at: http://wrox.books24x7.com