Closing form w/o save if field is null

[iDeals]

Okay so I have this code to open the form:

Private Sub Command141_Click()
DoCmd.OpenForm "frmAddBillable", , , , acFormAdd
Forms("frmAddBillable").fkProjectID = Me.fkProjectID

So this automatically creates a new record, however if nothing is entered say in field "Employee" I want the form to close without the new record being created. This was my attempt at a solution but it got very messy:

Private Sub Form_Unload(Cancel As Integer)
If (Nz(Me.Employee, 0) = 0) Then
   DoCmd.RunCommand acCmdUndo
   DoCmd.Close acForm, "frmaddbillable"
End If
End Sub

Any help would be appreciated. Thanks!

[June7]

This sort of record validation is usually done in form BeforeUpdate event. A common topic.

[iDeals]

thanks June, I will search the forum. When I googled it the forum it brought up said to use unload event instead of beforeupdate... I'm guessing now that it was based on the user's specific situation vs. the norm.

[NTC]

or don't open the form in Add mode, but regular mode.....and then just put a Command button on the form to Add New Record...... this is the most common approach.....