Hi,

I am having a problem running a macro which calls on 4 queries. Each one relies on data from the last one, they all seem to run properly except one which displays the message "this recordset is not updatable" down the bottom of the screen.

Anyone know what the problem is here and how I can fix it?


Russ

Here are 2 very common reasons for "not updatable" recordsets.

1. Missing primary keys: Make sure all of your tables have a primary key. Use an autonum if you must, but you are better of using a unique field or concatenated unique fields.

2. Grouping (Totals) queries: If you are using a grouping query as a subquery, it will not be updatable. Make a temp table out of the grouping query and use the temp table in place of the subquery.