I have a simple invoice form with a subform that allows the user to list part
numbers along with the quantity. The subform has a calculated field called
[PartTotal] that should take either the[LIST PRICE] or the [NET PRICE] and
multiply by [Quantity] to get a value.
The subform is based on a query that pulls from 2 tables. (tblPartPerClaim &
tblParts)
I've tried using the IIF function in the [PartTotal] field of the query, the
[PartTotal] field of the subform, and I've also tried leaving the text box on
the form view of the subform unbound and using code in the after update event
of the checkbox on the main form. The only time I got anywhere close was
when I used...
Part Total: CCur(Quantity*(IIf(frmClaim.chkCaseExtended = -1,[LIST PRICE],
[NET PRICE])))
....as another field in the query.
I have some information in a previous post with a similar subject line.
Thanks for everyone's help,
Shannan
--
Message posted via http://www.accessmonster.com