Hi JR,
When I have the subform open only, and then to into the update query, and in the criteria row I let the wizzard find reference field which is AID, then it shows the criteria [Forms]![frmActions]![AID]
I also changed the synthax to the one you suggested, but as before when I update the...