open a specific form

[actiondave]

I have a table that depending on a certain field in that table it will be able to open a specific form.

In other words I have multiple forms but only want a specific form opened when accessing a record if that record has a field with certain criteria

if that makes any sense

thanks

 

[jwhite]

Try this in a module within the form (not tested). The parameter (strIn) is the value of the field to test:

Private Sub FormToOpen(strIn) As String

    Dim strtemp  As String

    strtemp = ""

    Select Case StrIn
        Case "1": strtemp = "frm1"
        Case "2": strtemp = "frm2"
        'etc.
        Case Else
            ' Do nothing, or something else
    End Select

    If Len(strtemp) Then
       DoCmd.OpenForm strtemp
    End If

    strtemp=""

End Sub