Popup for Required Field

[tbpowers]

I have a field on my form that, once populated, will close the record and lock down the fields. However there is one field that I want to require before allowing the user to close the record. How would I accomplish this? I would also like to create a message that states "The Qty field must be populated before you can close". Any help will be greatly appreciated.

 

[boblarson]

In the form's BeforeUpdate event put something like:

If Len(Me.YourTextBoxName & "") = 0 Then
    If MsgBox("You must populate the XXX field before closing.  Do you still want to close?", vbQuestion + vbYesNo, "Close?") = vbYes Then
       Cancel = True
    Else
       Cancel = True
       Me.Undo
    End If
End If

 

[tbpowers]

The code worked fine, but I am wanting to do something a little different. I want to lock a field based on another field.

The field that locks the form holds the initials of the user. When they try to type in their initials I want it to popup the message and require that the qty field be populated before they will be allowed to initial.

 

[tbpowers]

The code below works, I just don't know how to get it to throw the message "Actual Defect Qty must be entered" when a user tries to enter their initials.

Private Sub Disposition_App_QA_Click()
If IsNull(Actual_Defect_Qty) Then
Me.Disposition_App_QA.Locked = True
Else
Me.Disposition_App_QA.Locked = False
End If
End Sub