After using a combo box on a form, I get the following error message:
Can’t set Value to NULL when Checkbox property = FALSE
I’d like to get rid of this error message, if possible.
I have attached a file showing the contents of the table CorpNames.
In spite of the number of records, the table CorpNames reflects only 2 corporations. But these corps have gone through several name changes.
The form is meant to record new name changes and includes: a combo box (to select from the existing or current corporate names); a text box to input the new corporation name; and a date picker to record the EffectiveDate of the name change. (NOTE - The combo box is based on a query which returns only 2 records from the above table: the record for A4 Inc. and the record for B5 Ltd.)
As for the error message, I’m not sure if I need to adjust one of the properties of the table’s fields. Or whether I need to adjust one of the controls of the form.
Any suggestions?