need workaround - nonupdatable recordset
Posted on 2014-04-22
Dear experts -
I have a continuous form; my goal is to allow users to select multiple records via a checkbox. This checkbox was initially set up using a temp table, linked to the main table.
The main table has a lot of other linkages, so that we can display other fields in a user-friendly way.
This HAD been working fine, but now all of a sudden is not - and I can't trace the reason. One person told me that any table linked to others would make the recordset nonupdatable (although this is not the case in many other places in our system).
The main table IS linking to a few other queries - NONE of them has any calculations.
ALL underlying tables have primary keys.
Any ideas how to work around this, or come up with an alternative solution?