Form entry locked :: join key not present

J

jason

Wierd. I have a great inner join query which I allows
me to add, modify, and delete records inside the query panel.

But when I build a form on top of the query it does not allow me to input
NEW records. Status Bar says:

"Join Key of table Listings is not in the recordset"

This does not makes sense as the underlying query has the Primary Key of the
Listings table.

Anyone know how to correct this - thanks in advance
- Jason
 
K

Ken Snell

You'll need to post the SQL statement of the query. That will help identify
why the query is not updateable.

Also describe the table relationships and structures for the tables in the
query.
 

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

Trying to create a report that will list unmatched records by Ticket Primary Key 0
join key of table Car_Model_Variants not in recordset 2
With a Query in Access 2007, How can I Create This Query 3
Problem with errror 3341 6
Relationship with a Primary Key? 4
Self-Join Relationship Problem 3
Problem with jet database 3
Recordset not updateable message displayed when form opens 1

Top