Cant update subform with a query as RecordSource

[wrek]

What I'm trying to do is pretty basic (braincramp):

I have two tables Status-DocEC and DocECInfo.

On my form, I need fields from BOTH tables...details from the DocECInfo table, as well as fields from the Status table which users will need to edit...

Problem: The form wont allow me to update the Status-DocEC fields, I'm presuming because my record source is a query.

(Cant use subforms in a continuous form...tried relationships etc)

anyone?

 

[wrek]

OK:

SQL:

SELECT [STATUS - DOCEC].[Update From], [STATUS - DOCEC].Incorporated, [STATUS - DOCEC].[CDOCs Inc Note], [q16 - Display].[ROOT DCP EC], [q16 - Display].[ROOT DCP], [q16 - Display].[ROOT DCN EC], [q16 - Display].[ROOT DCN EC REV], [q16 - Display].DOCUMENT_TYPE, [q16 - Display].DOCUMENT_SUB_TYPE, [q16 - Display].DOCUMENT_NBR, [q16 - Display].DOC_SHEET_NBR, [q16 - Display].DOC_INCORP_FLAG, [q16 - Display].[DCP EC], [q16 - Display].[DCP EC REV], [q16 - Display].[DCN EC], [q16 - Display].[DCN EC REV], [q16 - Display].[FC EC], [q16 - Display].[FC EC REV], [q16 - Display].DCP, [q16 - Display].[DCP STATUS], [q16 - Display].[DCP STATUS DATE], [q16 - Display].[DCP TITLE], [q16 - Display].[DCN RESP_ENGINEER], [q16 - Display].[DCN STATUS], [q16 - Display].[DCN STATUS DATE], [q16 - Display].DCN_EC_TYPE, [q16 - Display].[DCN TITLE], [q16 - Display].DCN, [q16 - Display].[FC TYPE], [q16 - Display].[FC STATUS], [q16 - Display].[FC STATUS DATE], [q16 - Display].[FC TITLE], [q16 - Display].[FC ALTREF], [q16 - Display].DOC_STATUS, [q16 - Display].DOC_STATUS_DATE, [q16 - Display].MaxRev, [q16 - Display].Rev_Date, [q16 - Display].Rev_Status, [q16 - Display].Title, IIf(IsNull([DCP EC]),"",TLZ([DCP EC])) AS tDCPEC, IIf(IsNull([DCN EC]),"",TLZ([DCN EC])) AS tDCNEC, IIf(IsNull([FC EC]),"",TLZ([FC EC])) AS tFCEC, IIf(IsNull([DCP]),"",TLZ([DCP])) AS tDCP, IIf(IsNull([DCN]),"",TLZ([DCN])) AS tDCN, [ROOT DCN EC] & [ROOT DCN EC REV] AS Sort1, [DOCUMENT_TYPE] & [DOCUMENT_SUB_TYPE] & [DOCUMENT_NBR] & [DOC_SHEET_NBR] AS Sort2, [DCP EC] & [DCP EC REV] AS Sort3, [DCN EC] & [DCN EC REV] AS Sort4, [FC EC] & [FC EC REV] AS Sort5, [q16 - Display].CHECKIN, [q16 - Display].DocXREF, [q16 - Display].ECXREF
FROM [q16 - Display] INNER JOIN [STATUS - DOCEC] ON ([q16 - Display].ECXREF = [STATUS - DOCEC].ECXREF) AND ([q16 - Display].DocXREF = [STATUS - DOCEC].DocXREF);

ScreenShot of Relationships attached

q16 - Display is a query
Status - DOCEC is a table

Thanks.

 

[wrek]

Thank you Pat,

It turned out being an aggregate function (groupby) in the underlying query...should've seen that.

As for the naming conventions, I agree whole-heartedly -- problem is, I 'took over' this database from it's designer, and renaming all his objects would be a chore and a half...

...I prefer to look at the bright side, at least he didn't embed smiley's into his table names.