K
Kirstie Adam
All,
I am using the contact management template database and editing it to suit
our needs.
(I have changed the Calls table to a Meetings table)
However, now i can't get part of it to work. When i open up the Contacts
form, and then hit the Calls button (now called Meetings), the Meetings form
opens up. But when i try and enter a row with date, time, notes etc, it
tells me
"The field 'Meetings.ContactID' cannot contain a null value because the
required property for this field is set to True. Enter a value in this
field."
I don't understand why this is doing this, as in the template database it
works fine, and auto-populates the ContactID field in the Call table. Why
will it not auto-populate it in my new dbase? All i have done is change the
table and form names.
The field ContactID in the Meetings / Calls table is set up as a combo box,
with the row source as follows:
Select [ContactID],[LastName] & "," & [FirstName] From [Contacts] ORDER BY
[LastName] & "," & [FirstName];
Can anyone help?
Kirstie
I am using the contact management template database and editing it to suit
our needs.
(I have changed the Calls table to a Meetings table)
However, now i can't get part of it to work. When i open up the Contacts
form, and then hit the Calls button (now called Meetings), the Meetings form
opens up. But when i try and enter a row with date, time, notes etc, it
tells me
"The field 'Meetings.ContactID' cannot contain a null value because the
required property for this field is set to True. Enter a value in this
field."
I don't understand why this is doing this, as in the template database it
works fine, and auto-populates the ContactID field in the Call table. Why
will it not auto-populate it in my new dbase? All i have done is change the
table and form names.
The field ContactID in the Meetings / Calls table is set up as a combo box,
with the row source as follows:
Select [ContactID],[LastName] & "," & [FirstName] From [Contacts] ORDER BY
[LastName] & "," & [FirstName];
Can anyone help?
Kirstie