R
RB
Hello,
I have a form in my database used for entering new data into a table.
Some of the fields in my table are required, others are not. If I
start entering a new record, using the form, but only fill in some of
the fields, and then click a button, to, for example, open another
form (i.e. I have decided that I do not want to add this new record
now), I will get the following error message:
The field 'MyTable.MyField' cannot contain a Null value because the
Required property for this field is set to true. Enter a value in this
field.
What I want is for the record not to be added unless I have clicked
the 'Add New Record' command button. Can I do this? Or, can I in any
way stop this error message from appearing?
I hope you can help,
Thanks,
Richard
I have a form in my database used for entering new data into a table.
Some of the fields in my table are required, others are not. If I
start entering a new record, using the form, but only fill in some of
the fields, and then click a button, to, for example, open another
form (i.e. I have decided that I do not want to add this new record
now), I will get the following error message:
The field 'MyTable.MyField' cannot contain a Null value because the
Required property for this field is set to true. Enter a value in this
field.
What I want is for the record not to be added unless I have clicked
the 'Add New Record' command button. Can I do this? Or, can I in any
way stop this error message from appearing?
I hope you can help,
Thanks,
Richard