New Unexpected Message

[Richie2837]

Our contacts database has a sub-form for recording calls from our clients. Apparently for no reason when I try to enter information into it, it has suddenly started displaying the message "The field 'Calls.ContactID' cannot contain a Null value because the required property for this field is set to True. Enter a value in this field". What could have happened to have prompted this message to appear?

 

[MStef]

It says that you must enter a data in "ContactID" field.

 

[Richie2837]

which is what I find strange because "ContactID" is an autonumber on the main contacts table assigned to clients, and this refers to the name of the client on the Calls sub-form, so why has it now stopped populating from the main form?

 

[MStef]

In that case populate "LINK CHILD FIELDS" and "LINK MASTER FIELDS" (properties) in your Main Form.

 

[boblarson]

And make sure that the field exists on your subform (it can be hidden, but has to be on the form).