Error message: Null values

[fateyes]

Hi,

I am getting this error in a subform that i am using. It is the 'Calls' subform in Microsofts 'Contact Management' database template. The only thing that I have altered in it is putting a drop down list section for the subject.

This is the error i get:

'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.'

I dont understand it because the contactID is a linking field that uses the primary key from the other table (contacts) - why does it think no value is being entered?

Thanks for any help,

Fateyes

 

[glynch]

It sounds like you might be trying to add a contact to the Calls table before it exists in the Contact table. If Calls is the "many" side of a one-to-many relationship, you would need to add it first to Contact table. If that is the case you could pop up a form to add a Contact record, closeit, and have the new contact value appear in the combo in the Calls subform.

I am speculating as to what you are trying to do, it wasn't totally clear from your description.

Hope this helps.