Field cannot be updated error

[anoble1]

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.

[Buk1tH3d]

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.

[Rabbit]

Take a look at this thread: https://bytes.com/topic/access/insig...-non-updatable

[anoble1]

Found an error that popped up today that could be the issue.

What does that mean?