Automatically populate field

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top