I am struggling with a new issue that revolves around the inability to update a query with a calculated field. I have a datasheet form with fields that include [item], [rawingredient], [mixcode] and [process]. I would like to be able to update the [process] field, but [mixcode] is a calculated field in the query that displays [mixcode] for an [item] if it is different from the [rawingredient] with an "Iif" statement. As has become abundantly clear on this group and in Access Help, you cannot update data in a query with a calculated field. So, I would like to include an unbound control in a subform with datasheet view that would provide the [mixcode] information for a given [item] and [rawingredient] and still allow me to change [process]. So, the subform is bound to "tblItemProcess" with fields [item], [rawingredient] and [process], and query "qryItemMixCode" includes fields [item], [rawingredient] and [mixcode]. [mixcode] is a calculated field (Iif Statement) that determines if the rawingredient is actually part of an assembly. I have tried a dlookup up formula, such as "=dlookup("mixcode","qryitemmixcodes","[item] = """ & me![item] & """ & "[rawingredient] = """ & me![rawingredient] & """")" , but I get an error from Access that "You may have entered an operand without an operator." Any thoughts?