If DCount("*", "[HistoryCM]", "[Local_ID] = '" & Me.Local_ID & "' AND [Noun] = '" & Me.Noun & "'") And Nz(Me.Status, 0) = 0 Or Nz(Me.Status, 0) <> "Open" > 0 Then
MsgBox "The Corrective Maintenance of this Equipment is already Open. Open CM of An Equipment cannot be duplicated"...