What's up with NULL??

[lipin]

I have a form to enter attendance data. When I have entered all I am going to, I try to close form and get "Invalid Use of Null" because there is no number in employee number text box, well I am done, with no new numbers to enter. I set all the properties in the table to 'not' required and there is no primary key, so why can't it be null just to close the form? I can close form by just hitting end two times at error message box, but would rather not have to. How can I close the form or leave the form to go back to menu form without getting the error?

 

[David R]

Is your form entering some data by default on a new record? If you haven't started your new record you should be able to get out of it okay.

Check the Required and AllowZeroLengthString properties on your table fields, as well as the code events to make sure it's not starting a partial record for you accidentally.