I have a subform displayed in Datasheet view with the followign fields:
Product Number (cbo), Product Name (cbo), Quantity, Discount %, Unit Price,
SupplierID, and Product Number (Ref.)

I want the user to select an item using the pull-down menu, enter a quantity
and have the subform calculate the amount charged based on the discount
that's stored elseware, the unit price and the quantity.

This is the formula I have and it's not working for some reason:
=IIf(IsNull([Quantity]),0,(Sum(([Quantity]*[Unit
Price])-([Quantity]*[Discount]*100)/100*[Quantity])))

I'm getting an #ERROR in all fields...

I then must sum all of the values that come from the calculation above to
display on the main form. Totaling the "ExtendedPrice" is where this issue
began... For some reason I can't seem to make it work...

Any help would be greatly appreciated. If you more details are required, let
me know and I'll send them along... Thx so much!!