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