Re: Need check box to change formula used in subform source
- From: pietlinden@xxxxxxxxxxx
- Date: 31 Aug 2005 06:00:12 -0700
use the IIF function. You're probably going to need Keri's article on
referring to controls etc from AccessWeb, which is here
http://www.mvps.org/access/forms/frm0031.htm
and then you'd do something ilke
TotalPrice=Quantity * (IIF(ParentForm.CheckBox=Checked,
[ListPrice],[NetPrice]))
Of course, you're going to have to read Keri's article and get the
exact syntax down for referring ot the right control, but that should
do it.
.
- References:
- Need check box to change formula used in subform source
- From: Shannan Casteel via AccessMonster.com
- Need check box to change formula used in subform source
- Prev by Date: Re: Adding a column in report
- Next by Date: Re: Display one to many records in a mail merge
- Previous by thread: Need check box to change formula used in subform source
- Next by thread: Handling Apostrophes
- Index(es):
Relevant Pages
|
