Forms

[dr223]

Hi,

My database when it loads it goes to a new record as programmed, then if you click any field on the form the following message is seen. And unless you leave the record / form it will always pop up.

"Index or primary key can't contain a null value".

Please not student_id was sent as the primary key. Is there a way to neglect this message, so that I can easily click any other field without it popping.

Thanks

 

[ted.martin]

All records must have a Primary key number and the error message is telling you that you cannot create a record unless the Primary Key has a value. Given the student-id would seem to be a sensible unique value, I assume you must be trying to close the form without this field haveing been filled in.

A way around this would be to design into your table a new field called (say) number and give it the Autonumber property, this should allow your form to behave as you wish.