If ststement problem

Topic

New Reply

I am trying to open a second form if the correct values are in the “department” and “Audit Type” fields on the first form with the following code:

Private Sub Audit_Type_AfterUpdate()
If “Department = BND” And “Audit Type = First Piece” Then
DoCmd.OpenForm “frmEnterBNDFirstPieceStatus”, acNormal

Else
End If
End Sub

Can’t get this to work. Any help?

Reply | Quote

Replies

have you tried
If Department = “BND” And [Audit Type] = “First Piece” Then
HTH

Reply | Quote

If your field names are “Department” and “Audit Type”, the following should work:

Private Sub Audit_Type_AfterUpdate()
If Me.Department = "BND" And Me.Audit_Type = "First Piece" Then
    MsgBox "Yup"
Else
    MsgBox "Nope"
End If
End Sub

Reply | Quote