Join Key not in recordset

[nicola]

Hello
I have created a form based on a table called T_Model which contains (among
others) the fields VORNAME (first name) and NACHNAME (surname). When I try to
write into these respective fields of my form, the cursor is blocked and I
can't write anything and I get the error message "Cannot add record(s). Join
Key of Table T_Model not in recordset. What is the reason for this error
message and how can I fix the problem?

Thanks for feedback and best regards
Nicola

 

[John W. Vinson]

Hello
I have created a form based on a table called T_Model which contains (among
others) the fields VORNAME (first name) and NACHNAME (surname). When I try to
write into these respective fields of my form, the cursor is blocked and I
can't write anything and I get the error message "Cannot add record(s). Join
Key of Table T_Model not in recordset. What is the reason for this error
message and how can I fix the problem?

Thanks for feedback and best regards
Nicola

It sounds like the form is based, not on T_Model, but on some query joining
T_Model to some other table. Could you post the SQL view of the form's
Recordsource? What tables is T_Model related to, by which fields? Is that
field in fact in the recordsource?

 

[nicola]

Hello John

I was able to solve the problem by deleting the erroneos fields and dragging
the original table fields again onto the form. Thanks for your help and best
regards
Nicola