I have a continous subform that lists product name, unit price, qty, and extended price. I have a combo box set to the product name, and I have a default value on the Item Unit Price (=DLookup("[ProdUnitPrice]", "tblProduct", "[ProdID]= '" & [Me]![ItemProdID] & "'"
When entering in a new sale line item order, everything works fine, except that the next line, (which contains no data) gives a #Name?, under the unit qty on the next blank row. This prevents the sub-totaling etc. How do I keep the next blank row clear.
I posted this before, but does anyone know a code that I can use to keep the next row, which is blank and ready for data entry,totally blank. I think I am getting the #Name? error on the blank row because it is looking for a value, which there would be none until the person starts adding it.
Thanks again.
Susan
When entering in a new sale line item order, everything works fine, except that the next line, (which contains no data) gives a #Name?, under the unit qty on the next blank row. This prevents the sub-totaling etc. How do I keep the next blank row clear.
I posted this before, but does anyone know a code that I can use to keep the next row, which is blank and ready for data entry,totally blank. I think I am getting the #Name? error on the blank row because it is looking for a value, which there would be none until the person starts adding it.
Thanks again.
Susan