help with null

[lipin]

I have a form that has a Employee Number combo box. When you enter the number the employee name shows in the Empl Name txtbox. (I am using an ADD RECORD command button that saves the record and clears the fields for teh next entry.)Everything works fine until you have entered all you are going to and go to exit the form. Everytime you try to exit the error Invalid use of Null pops up.
I tried:
If txtEmplNumber = Null Then
Exit
in the code of the add record button
but it didn't help. I would like the form to close with no error and not saving a blank record. Any Ideas?? Thank You.

 

[John.Woody]

Try the following

If isnull(txtEmplNumber) then exit sub

or

If isnull(txtEmplNumber) then
Docmd.close
end if

 

[lipin]

Thanks a lot. Worked like a charm(the top suggestion).
Really appreciate it.