I designed my form to open blank when it loads. I have a field (AppDate) which I set it's Required property to True. The problem I'm having is that when I try to close the form without entering any data, I get a message saying: The field 'tblName.AppDate' cannot contain a Null value because the Required property for this field is set to True. Enter value in this field.
You can either get the user to enter the date or before entering the form, get the user to set the Current Working Date (global variable or an opening argument that you create) which could default to the system date to make sure it is not null. The second option is more restrictive though.
I sometimes create hidden unbound fields to store information from record to record. As the user enters one record and sets the date, I save that date to the hidden field. When the user starts the next record, I automatically set the date to the value in the hidden field. IF the user changes the date, the hidden field will be updated manually by the program again.