Full Version: Total subform percent for each form
UtterAccess Forums > Microsoft® Access > Access Forms
I have a form :
I have a subform:
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.
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!
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.