Record set is not Updatable

[greatwhite]

OK I have inherited a MS Access DB to fix up that was never completed.



My Main Form has a Subform will call SubPanelBreakerEven. When I try to change a value in the Combox I get a message Record not Updatable.

This form is based on a Query the Record set type is Dynaset, Allow Edits = Yes

The form query is very simple.

SELECT tblEquipPanelBreaker.keyCableDn, tblEquipPanelBreaker.optA103, tblEquipPanelBreaker.strA103, tblEquipPanelBreaker.strBreakerSize, tblEquipPanelBreaker.numBreakerDetailRow, tblEquipPanelBreaker.numBreakerPosition, tblEquipPanelBreaker.keyEquip, tblEquipPanelBreaker.keyEquipPanelBreaker, tblEquipPanelBreaker.strPhase1, tblEquipPanelBreaker.strPhase2
FROM tblEquipPanelBreaker
WHERE ((([numBreakerPosition] Mod 2)=0))
ORDER BY tblEquipPanelBreaker.numBreakerPosition, tblEquipPanelBreaker.numBreakerDetailRow;




The Comboboxs to make the changes are also query based and has a control Source as well.

When I try to select a new value in the combox I get the message Record set is not Updatable. The query used for the combox is

SELECT tblBreaker.strBreakerSize, tblBreaker.strPanelType
FROM tblBreaker
WHERE (((tblBreaker.strPanelType)=[Forms]![frmEquip]![fsubEquip].[Form]![strPanelType]));




I cannot seem to figure out why

[ranman256]

if the query has joins, then its possible the joins will not allow updates. It depends.

[greatwhite]

No joins the querys are above

[greatwhite]

OK My bad. I just checked the back end (The tables reside on another MS Access) and it was checked as not writable.