How can I do this on my form?

[pimek75916]

I want to make a pop box making a field mandatory
like this:

 

[theDBguy]

Hi. You can use the Form's BeforeUpdate event and check for empty/required input. For example:

Private Sub Form_BeforeUpdate(Cancel As Integer)

If IsNull(Me.Surname) Then
    MsgBox "You must enter the surname.", vbCritical,"Required"
    Cancel=True
End If

End Sub

 

[GinaWhipp]

Hmm, I use...

Validate Data

Access-Diva provides custom databases using Microsoft Access utilizing SQL Server when called for.

www.access-diva.com