flaw in Access?

[placek]

Hi

I am in the process of building a database, and have been
testing it all the while (about 2 weeks). Everything was
going as expected, with no major problems. Then out of the
blue i got the message.......

The field 'tblLoanRelation.lngBorrowerNumberCnt' cannot
contain a null value because the required property for
this field is set to true. Enter a value in this field.

When i get this message the program freezes. The field in
question never contains a null value when this message
appears, so i am left scratching my head. If i close the
form and go back into it the problem seems to disappear.
Is this a flaw in Access?

Many thanks, Martin

 

[Ken Snell]

Probably what's happening when this error message appears is that your form
is trying to save the current record, and no entry has been made yet for the
field in question. Many things can cause a form to save its record....so
it'll help if you can tell us more about the form's recordsource, the
actions that are occurring when the error occurs, etc.

 

[placek]

Ken

I think you are right. I seem to remember a new record was
created without the field in question. I'll have a look at
my code again to see what may be causing the problem. I'll
post again if i am stuck.

Thanks, Martin