Need help, please!
I have a Combo box in the Form when the field was selected from the list.
I want a Text box 2 to show a result when certain criteria are meet based on the data selected from the Combo box and another Text box 1 info.
e.g.
The Text Box 2 will have the same result as the Combo Box if the condition not met.
I have a Combo box in the Form when the field was selected from the list.
I want a Text box 2 to show a result when certain criteria are meet based on the data selected from the Combo box and another Text box 1 info.
e.g.
Case | Combo Box | Text Box 1 | Text Box 2 |
1 | APPU | DT1 or DT2 or N.A | ACCU |
2 | APPU | MP1 or MP2 or MI1 or MI2 | APPU |
3 | MPPU | DT1 or DT2 or N.A | MPPU |
4 | MPPU | MP1 or MP2 or MI1 or MI2 | LPPU |
5 | PECCU | Don't Care | PECCU |
The Text Box 2 will have the same result as the Combo Box if the condition not met.