error: join key not in recordset

P

Patty

What does the error "join key of table 'tablename' not in
recordset" mean? I am not able to enter new data on a
form.
 
J

Jeff Boyce

Patty

For Access to know which record to make the changes to, it needs to have a
key field. I suspect your error message is telling you that you don't have
the key field from the table you are trying to update/enter info to.
 

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

Similar Threads

Join Key not in recordset 2
"Run Time error 3156 ODBC Delete on a linked table TABLENAME failed" 0
fields cannot update in subform? 2
One form, two tables 1
Join key on table not in recordset 3
join key of table Car_Model_Variants not in recordset 2
Not in Recordset error 1
Recordset Not Updateable message 2

Top