Unanswered: Extra record row added to datasheet - how to delete?
I have a problem with subform fields in datasheet view. As in the diagram below, I have an expression set
so that when the Paid field (yes/no) is set to Yes, the OverdueCharge field is set to $0.00 (using an IIf statement) and
when the Paid field is set to No, the OverdueCharge field is set to $2.00. This works fine, except that an extra
record is always automatically added to the bottom of the form by the program. Because there is no data in the paid field of this record, the IIf statement considers its value as No (false) and
so the "extra" record displays the OverdueCharge field as $2.00, thus affecting the TotalCost field, which is set to
=Sum([Quantity]*[CostPerUnit])+[OverdueCharge]. What to do? This is really annoying and obviously in a practical situation
would give misleading transaction information to clients.