Q. It's not working again. "Record set is not updateable"

  • Thread starter Thread starter Jim Jones
  • Start date Start date
J

Jim Jones

Hi,

I decided to create a form from a query, where I included input from 2
tables. Each table has it's own PK.

The query displays the data just fine, but I'm unable to enter data,
to update the underlying tables via this one query.

Please help.

Thanks,
Jim
 
Jim Jones said:
Hi,

I decided to create a form from a query, where I included input from 2
tables. Each table has it's own PK.

The query displays the data just fine, but I'm unable to enter data,
to update the underlying tables via this one query.
Click to expand...

Multi-Table queries are often not updateable. There is a help topic that
discusses this and in some cases the query can be modified so that it is
updateable. In other cases you are better off with a form and subform each
bound to a single table/query.
 
Jim Jones said:
Hi,

I decided to create a form from a query, where I included input from 2
tables. Each table has it's own PK.

The query displays the data just fine, but I'm unable to enter data,
to update the underlying tables via this one query.

Please help.

Thanks,
Jim
Click to expand...

See the help topic "When can I update data from a query?".
 
You must log in or register to reply here.

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

Need combo box to refresh when moving to new record 2017 1
Update the report 9
Design of a simple sales entry database form 1
Access Access Report Works on One Machine but not Another 3
Can't update records in form with Query recordsource. 3
Q. Recordset is not updateable. 1
Update Not Allowed On Form 1
Form modifies record when it should not 1

Back
Top