sambucaman
Registered User.
- Local time
- Today, 15:34
- Joined
- May 6, 2010
- Messages
- 41
I'll have a stab at explaining this, and offer my thanks beforehand, for the time you're taking to read my problem.
Ok, I have a table called "contacts", which is linked to another table called "calls" the idea being that every time a customer calls I can enter a brief call history.
I have made a "contacts" form, and included a sub-form "calls"
When I open the form everything functions perfectly. I can add call notes to new or existing customer. If its an existing customer, I have to scroll through the records to find that customer...
So, I have created a query "*" & [Search by Name] & "*" which will search by name. The results don't really work for me in a datasheet view, so I have created another form (using the wizard) called "Search results"
This form is then formatted to look identical to the "contacts" form so I have a more user friendly result. I have added the sub form "calls" to my new form, with the thought that it would work exactly as the first "contact" form.
However, this time (in the "search results form") i get an error when trying to add data to the sub-form. I get
"The LinkMasterFields property setting has produced this error - the object does not contain the automation contacts contacts"
Then...
"The field Calls.ContactID cannot contain a null value because the required field for this property is set to True"
Any chance someone could explain exactly what I need to do to overcome this error. I have goggled, but cant seem to get a working fix - I'd really appreciate any help.
Many thanks in advance
Ok, I have a table called "contacts", which is linked to another table called "calls" the idea being that every time a customer calls I can enter a brief call history.
I have made a "contacts" form, and included a sub-form "calls"
When I open the form everything functions perfectly. I can add call notes to new or existing customer. If its an existing customer, I have to scroll through the records to find that customer...
So, I have created a query "*" & [Search by Name] & "*" which will search by name. The results don't really work for me in a datasheet view, so I have created another form (using the wizard) called "Search results"
This form is then formatted to look identical to the "contacts" form so I have a more user friendly result. I have added the sub form "calls" to my new form, with the thought that it would work exactly as the first "contact" form.
However, this time (in the "search results form") i get an error when trying to add data to the sub-form. I get
"The LinkMasterFields property setting has produced this error - the object does not contain the automation contacts contacts"
Then...
"The field Calls.ContactID cannot contain a null value because the required field for this property is set to True"
Any chance someone could explain exactly what I need to do to overcome this error. I have goggled, but cant seem to get a working fix - I'd really appreciate any help.
Many thanks in advance
