Error - This recordset is not updateable on form

[anoble1]

I have a small database i just created with 3 tables being used. 2 of the tables are linked tables from a SQL server. One is a local table that i made where i can make notes based on the main data from the other tables if something has been completed. All tables have a primary key. Like i said 2 linked tables and 1 local table.
I have 2 attachments. Any help would be appreciated. When i try to click the "Active" field is when i get the error. It is Enabled and unlocked.

[imgnothumb]http://bytes.com/attachment.php? attachmentid=83 79 [/imgnothumb]
[imgnothumb]http://bytes.com/attachment.php? attachmentid=83 80[/imgnothumb]

[Rabbit]

That's not going to be an updateable recordset as you've seen. You'll have to separate it out and manage the updates through either a subform or through VBA code.

[zmbd]

From an old Bytes.com thread; Microsoft Answers the question:
When can I update data from a query?