Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.
After I close the message I immediately click on the command button Close. Here's the code:
Private Sub StoreID_BeforeUpdate(Cancel As Integer) If DCount("*", "tblDesignatedEmployee", "[StoreID]= " & Me.StoreID) > 0 Then Beep MsgBox "This Store already has assigned employees. If you need to modify exisiting employees return to Maintenance and select Modify Designated Employee" Cancel = True Exit Sub End If End Sub
Private Sub cmdClose_Click() On Error GoTo Err_cmdClose_Click If Me.Dirty Then Me.Undo End If DoCmd.Close DoCmd.OpenForm "frmMaintenance" Exit_cmdClose_Click: Exit Sub Err_cmdClose_Click: MsgBox Err.Description Resume Exit_cmdClose_Click End Sub
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
20 Experts available now in Live!