Check box changes formula used in subform
- From: "Shannan Casteel via AccessMonster.com" <forum@xxxxxxxxxxxxxxxxx>
- Date: Tue, 30 Aug 2005 12:49:11 GMT
I have a subform for listing parts. It has fields including: ClaimID, ITEM,
NET PRICE, LIST PRICE, Quantity, Supplier, and a calculated field called Part
Total. The subform is based on a query. The Part Total field is calculated
as (=[tblParts].[NET PRICE]*[tblPartPerClaim].[Quantity]). Then there is a
hidden text box on my subform that calculates the sum of all the Part Totals
for each claim. There is another field on my main form set equal to this
field on the subform.
My question is: Can I have a check box on my main form that, if checked,
would apply a formula to use the LIST PRICE in the calculation instead of the
NET PRICE?
I imagine that I would enter some sort of criteria statement under the
query's calculated fields.
I appreciate any help.
Thanks,
Shannan
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/200508/1
.
- Prev by Date: Re: Migration to Postgres
- Next by Date: Re: Displaying and modifying 1:N data in forms?
- Previous by thread: how to open code builder for default when click on event builder in forms
- Next by thread: how to check list box
- Index(es):
Relevant Pages
|
