Record updatability

  • Thread starter Thread starter Michael Wong
  • Start date Start date
M

Michael Wong

I have a recordset (containing ProductId) that is the result of a join
(criteria selected from the user).
I would like to apply an update query to this recordset but it is not
updatable.

Is there any solution?

A solution I am thinking is to create another query based on a single table
(TProduct). The query would retrieve the records where ProductId is also in
the recordset resulting from a join. How can I do it?
 
Michael

A recordset needs to contain the primary key of the table to be updated to
be updateable. Try also checking Access HELP on the subject of
"updateable".
 
Thanks Jeff,

I had to add another query based on one table, using IN in the where clause
and it worked.
 
Back
Top