lookup

[jlute]

Hi, there!

This works fine in the Record Source of my subform:
IDCubecuin: IIf(Nz([IDLength],0)<>0,
[IDLength]*[IDWidth]*[IDHeight]*[cuinConvFactor],
[IDWidth]*[IDWidth]*[IDHeight]*[cuinConvFactor])


The Record Source is:
SELECT tblPKPhysicalAttributes.*, IIf(Nz([IDLength],0)<>0,
[IDLength]*[IDWidth]*[IDHeight]*[cuinConvFactor],
[IDWidth]*[IDWidth]*[IDHeight]*[cuinConvFactor]) AS IDCubecuin FROM
tblPKPhysicalAttributes INNER JOIN tblUOMLength ON
tblPKPhysicalAttributes.IDLUOM = tblUOMLength.txtUOMLength;


The inner join of tblUOMLength is the problem. It results in an un-
updatable subform.


Is there a way I can lookup tblUOMLength so that the subform can be
updatable?


Thanks for your help!