POP UP Message - validation test

[akhlaq768]

Is it possible to check if the fields and drop down boxes are all complete before the records are submitted from the form?



I am using a COMMAND button on my form that will save the entries from the form into a database, but i want all the entries to be completed before it is submitted, so i want a pop up message to notify the user to complete all entries

[akhlaq768]

ANSWER -

Private Sub btnNewOrder_Click()
Dim intanswer As Integer
If isNull(Forms!frmnavigation!cmbDistributionOrder) Then
    intanswer = _
        MsgBox("No Distribution selected, please select from list", vbInformation + vbOKOnly, "Select Distribution")

        Else
    
    Forms!frmnavigation.Visible = False
    DoCmd.Minimize
DoCmd.openForm ("tblOrder"), acNormal, , , acFormAdd
End If
End Sub