Query Based Form is now Read Only

[aball65]

I changed a form's record source to a query (RISK_FORM_QUERY) and now it will not allow me to make any data updates. It's appears to be in some kind of read-only mode. Here's the query:

SELECT
RISK.r_id, RISK.rl_id, RISK.rpg_id, RISK.rpj_id, RISK.owner, RISK.RMCS_id, RISK.statement, RISK.rci_id, RISK.rsi_id, RISK.rpi_id, (R_COST_IMP.value+R_SCHED_IMP.value+R_PERF_IMP.value) AS total_impact, RISK.rpb_id, R_PRIORITY.value, RISK.open_date, RISK.close_date, RISK.rrs_id, RISK.rtf_id
FROM
RISK, R_COST_IMP, R_SCHED_IMP, R_PERF_IMP, R_PROB, R_PRIORITY
WHERE
RISK.rci_id=R_COST_IMP.rci_id And RISK.rsi_id=R_SCHED_IMP.rsi_id And RISK.rpi_id=R_PERF_IMP.rpi_id And RISK.rpb_id=R_PROB.rpb_id And (RISK.rpb_id=R_PRIORITY.rpb_ID And (R_COST_IMP.value+R_SCHED_IMP.value+R_PERF_IMP.value)=R_PRIORITY.total_impact);

Are query based forms read only?

Thanks in advace

 

[missinglinq]

DEpends on the query! Here's Allen Browne's paper on the sugject, which may help:

http://allenbrowne.com/ser-61.html

 

[aball65]

I simplified the query (see below) yet it is still unupdateable. I'm doing real basic joins here:

SELECT
RISK.r_id, RISK.rl_id, RISK.rpg_id, RISK.rpj_id, RISK.owner, RISK.RMCS_id, RISK.statement, RISK.rci_id, RISK.rsi_id, RISK.rpi_id, RISK.rpb_id, RISK.open_date, RISK.close_date, RISK.rrs_id, RISK.rtf_id
FROM
RISK, R_COST_IMP, R_SCHED_IMP, R_PERF_IMP, R_PROB
WHERE
RISK.rci_id=R_COST_IMP.rci_id
And RISK.rsi_id=R_SCHED_IMP.rsi_id
And RISK.rpi_id=R_PERF_IMP.rpi_id
And RISK.rpb_id=R_PROB.rpb_id;

Can anyone tell me what makes this query unupdateable??

Thanks!