Question Locked
0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Ok in a form I have 6 fields. The first four fields I want to add and then subtract the last two from that giving me a calculated total upon changing any of the 6 fields in the 7th (or total) field.
3 replies
by claire.ringel Accepted solution
Clarifications
by larryd4 Accepted solution
You could either write in a command for the default value of the 7th field, such as.
=[Field1]+[Field2]+[Field3]+[Field4]-([Field5]+[Field6])
But with the above you have to stimulate the calculation with an onFocus event.
Or you can simply write a VBA Macro for the onEnter event for Field7 that would look something like
Field7.value = Field1.value + Field2.value etc...
by vdanelia Accepted solution
Thank You for such smart and very useful example
This discussion is closed to new replies.
Trending Software posts
Sort by Trending
1 helpful
1 reply
Question Unanswered
How Are Teams Testing AI-Generated Code Before Production?
0 helpful
0 replies
0 helpful
5 replies
0 helpful
20 replies
Discussion
Is There any Reverse Video Search Tool
0 helpful
8 replies