Subform Help

[qad122]

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.

 

[RickSpr]

The syntax for your Default property is invalid. It should be:
DLookup("[ProdUnitPrice]", "tblProduct", "[ProdID]= '" & [Me]![ItemProdID] & "'")

If that's what you actually had and what you gave us just had typos in it, try again.
Rick Sprague
To write a program from scratch, first create the universe. - Paraphrased from Albert Einstein

 

[qad122]

Hey Rick,

Sorry for the "typos", but I do have the correct sequence in my database. I don't know if this helps, but I do put a requery in, and I am thinking that the subform just needs to possibly refresh itself? I have no idea...