Query not updateable, yet in form it is.

[MSROOKIE]

Have the following query which is not updateable when I open it:

SELECT PlaysByBar_Int_5_Full.Ticker, PlaysByBar_Int_5_Full.[BTO DT],
PlaysByBar_Int_5_Full.[STC DT], PlaysByBar_Int_5_Full.PutPrft,
PlaysByBar_Int_5_Full.CallPrft, PlaysByBar_Int_5_Full.PRisk,
PlaysByBar_Int_5_Full.CRisk, PlaysByBar_Int_5_Full.PutRR,
PlaysByBar_Int_5_Full.CallRR, PlaysByBar_Int_5_Full.Volume,
PlaysByBar_Int_5_Full.BGapDay, PlaysByBar_Int_5_Full.TGapDay,
PlaysByBar_Int_5_Full.CR4Bar, PlaysByBar_Int_5_Full.PR4Bar,
PlaysByBar_Int_5_Full.CR3Bar, PlaysByBar_Int_5_Full.PR3Bar,
PlaysByBar_Int_5_Full.[1PrevBar], PlaysByBar_Int_5_Full.[2PrevBar],
PlaysByBar_Int_5_Full.[3PrevBar], PlaysByBar_Int_5_Full.[4PrevBar],
PlaysByBar_Int_5_Full.[5PrevBar]
FROM PlaysBestByBar_Int_5_Tbl INNER JOIN PlaysByBar_Int_5_Full ON
(PlaysBestByBar_Int_5_Tbl.Ticker = PlaysByBar_Int_5_Full.Ticker) AND
(PlaysBestByBar_Int_5_Tbl.[BTO DT] = PlaysByBar_Int_5_Full.[BTO DT]) AND
(PlaysBestByBar_Int_5_Tbl.PutPrft = PlaysByBar_Int_5_Full.PutPrft)
ORDER BY PlaysByBar_Int_5_Full.Ticker, PlaysByBar_Int_5_Full.[BTO DT],
PlaysByBar_Int_5_Full.[STC DT];

The input query and table being joined are both updatable.

Yet....

When I put this query in as a recordsource to a form, I can update the fields.

Both the query and the form recordset are set to dynaset. The sql statments
in the query and the recordset are identical.

Only difference is the form has a filtered, but putting in criteria in the
query does not make it updatable.

Any ideas why? I'm going nuts here.

Thx.

 

[MSROOKIE]

Correction...... it does seem to be the filtering. If I keep the filter in
the form, or do some type of criteria in the form, then it is updateable. If
there is no criteria, it is not updateable. Does not appear connected to any
group of records.

Hope that helps.