I have a 'save' button (they dont know access saves automatically)
and a flag in Unload event to validate
usage:
if IsValidForm() then ' allow to close form
Code:
Private Function IsValidForm() As Boolean
Dim vMsg
Select Case True
Case [Status] = "Closed" and IsNull(txtCloseDate)
vMsg = "Closed Date field missing"
Case IsNull(cboUser)
vMsg = "Teacher name is missing"
Case IsNull(cboSubj)
vMsg = "Subject field is missing"
End Select
If vMsg <> "" Then MsgBox vMsg, vbCritical, "Required Field"
IsValidForm = vMsg = ""
End Function