Field not included in calculation when hidden

S

Shemp

I have a few controls within an Optional Section that are part of a
calculation. Basically, it's part of a Sales Order doc I am working
up, and some customers will get a discount while others will not. The
ones that don't get a discount, I don't want them to know that a
discount is available.

All the discount info is within an Optional Section, but unless I show
txtDiscountAmount in the form, then txtGrandTotal (which depends on
txtDiscountAmount) returns NaN.

What I want to do is to set a conditional statement whereby, if the
Optional Section within which txtDiscountAmount resides is not made
visible by the user, then txtGrandTotal still works.

In other words, I am not sure how to create a formula within
txtGrandTotal that depends on whether txtDiscountAmount is visible. If
it's not, just total up txtSubTotal, txtShippingCharges, and
txtSalesTax.

Clear as mud? Thanks in advance!
 
S

Shemp

Perfect, thanks!

My biggest blocking issue is that I know what I want to do but I just
don't know the correct syntax. What's the quickest way to ramp up on
this? A web site? A book?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Document Merge Formatting Issue 0
Turning off automatic calculation 0
Open my default template when right click, select New MS Word doc within a folder 0
Need help finding old, outdated contacts in Outlook 365 on my PC 0
VBA to see if a Section exists in Word Document, and if it does, delete it 2
Grand Total on the main form 4
Converting URLs in comments to Markdown-formatted links 2
Auto-Numbering in a Table in MS Word 1

Top