Full Version: Total subform percent for each form
UtterAccess Forums > Microsoft® Access > Access Forms
daniels012
I have a form :
SampleBookFrm
I have a subform:
FlakeDetailSubform
In the FlakeDetailSubform there are 3 fields; Percent, FlakeId, Description
On the Form (or subform), I want to have a field, textbox or something that will sum the percent in red colored print, unless it is 100 percent.
Example:
Percent FlakeID Description
50 CF16 Rust
25 CF1 White
20 CF13 Black
In my desired box it would have a red 95 , because it does not equal 100
If I create a textbox, what code can I write to accomplish this?
Any help is greatly appreciated.
If I need more exlpaining please let me know!
Michael
jmcwk
Michael,
Have you looked at Conditional Formatting ?
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here.