By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,966 Members | 1,776 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,966 IT Pros & Developers. It's quick & easy.

Error - This recordset is not updateable on form

anoble1
100+
P: 230
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.


Attached Images
File Type: jpg database.jpg (28.5 KB, 429 views)
File Type: jpg database2.jpg (50.3 KB, 304 views)
Jun 22 '15 #1

✓ answered by 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.

Share this Question
Share on Google+
2 Replies


Rabbit
Expert Mod 10K+
P: 12,430
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.
Jun 22 '15 #2

zmbd
Expert Mod 5K+
P: 5,397
From an old Bytes.com thread; Microsoft Answers the question:
When can I update data from a query?
Jun 22 '15 #3

Post your reply

Sign in to post your reply or Sign up for a free account.