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

VBA word change keys 0
Help creating a search form in Access XP 0
sqlite-odbc write conflict 2
Join Key not in recordset 2
fields cannot update in subform? 2
Entering data with many to many relationship 1
Query to populate combobox with names of tables, only if they contain data 2
join key of table Car_Model_Variants not in recordset 2

Top