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

Field cannot be updated error

anoble1
100+
P: 229
I have been trying to trace this error for a couple of days but have not had any luck. I suspect it has to do with the recordsource of the form. I tried to debug it from the combobox but it happens before it does anything. As soon as you type the first letter in the box it throws the error. If you click Ok it continues and works.



Here is my recordsource from the form. When I hit run I don't get any errors and I see all the records on the datasheet in the query.

Attached Images
File Type: png Field Cannot be Updated.png (24.7 KB, 288 views)
File Type: jpg Query.jpg (85.4 KB, 286 views)
Dec 16 '19 #1
Share this Question
Share on Google+
3 Replies


P: 4
It appears you have relationships in your recordsource query that cannot be resolved when you click in the combobox. Try reworking your relationships in your query. Try to make your tblNames your primary table and other tables are joined using "left join" which is the #2 choice in the join properties. That might work for you.
4 Weeks Ago #2

Rabbit
Expert Mod 10K+
P: 12,383
Take a look at this thread: https://bytes.com/topic/access/insig...-non-updatable
4 Weeks Ago #3

anoble1
100+
P: 229
Found an error that popped up today that could be the issue.


What does that mean?
Attached Images
File Type: png Error.png (4.8 KB, 236 views)
4 Weeks Ago #4

Post your reply

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