lookup

J

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!
 
Top