Join Key not in recordset

  • Thread starter Thread starter nicola
  • Start date Start date
N

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
 
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
Click to expand...

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?
 
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
 
Back
Top