Error: "Field canot be updated"

[Tom]

I need some help with "overcoming" an error that is
produced in the form/subform mode.

Here are the details about the 3 tables that I'm working
with:

tblJobs:
- Field: JobID (Autonumber Primary Key)
- Field: JobTitle

tblEmployees:
- Field: EmpID (Autonumber Primary Key)
- Field: EmpName

tblJobAssignments
- Field: JobID (Number; Long Integer Primary Key)
- Field: EmpID (Number; Long Integer Primary Key)

The relationships are:
- JobID foreign key to tblJobs.JobID, one to many
- EmpID foreign key to tblEmployees.EmpID, one to many


Once I built the relationships and create a query, that
shows all 4 fields (both PKs plus the JobTitle & EmpName,
I can enter new records in the query SELECT view. The
During the add new record process, the autonumber PKs are
(obviously) created by Access and everything seems to
work fine.

Here's the problem now... I linked this query to a form
(via the wizard) in which the tblJobs is the main form
while the tblEmployees resides on it as a subform.

Now, when adding a new job or adding a new employee to an
existing job, I get the error "Field canot be updated" as
soon as I type in the first character of the job or name.

Once I click "ok", I then see that the form accepted the
previously typed 1st character and I then can continue to
enter the job title or employee name. I verified the
form properties and I don't see anything which indicates
that this query is a non-editable query (which again, in
the query SELECT view, it worked just fine).

Does anyone have an idea causes the error to pop up?
Besides, if this was truly an non-updatable view, why can
I continue to enter data after I acknowledged the error?

Thanks for any help!!!

Tom

 

[Ken Snell]

From your description, what the wizard built for you is a form that has the
tblEmployees as the recordsource of the main form and the tblJobs as the
recordsource of the subform. The wizard discarded your query and went
straight to the source tables to make the form. As such, you're not
accessing the tblJobAssignments table at all with your form.

Again, I request that you post here the actual recordsources of the main
form and the subform. Let's see what the wizard did to your form setup. I am
imagining that what it built is not what you wanted.