For some reason the submit button will only work for half the form

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • sschmidt460
    New Member
    • Aug 2015
    • 15

    For some reason the submit button will only work for half the form

    Code:
    Private Sub Submit_Button_Click()
    If IsNull(Me.Type_Text) Or Me.Type_Text = "" Then
        MsgBox "Please select criteria for Report Type.", vbExclamation, "Attention"
    Else
        If Me.Type_Text = "Requisitions" Then
            DoCmd.OpenForm "Date Form"
        Else
            If [Forms]![Report Form]![Equipment Combo] = "" Then
                DoCmd.OpenReport "Equipment Inventory Report", acViewPreview
            End If
        End If
    End If
    End Sub
  • Seth Schrock
    Recognized Expert Specialist
    • Dec 2010
    • 2965

    #2
    A lot more explanation is needed in order for us to help you. What are you trying to do, what form, what controls, etc.

    Comment

    Working...