Hi all
I have a continuous subform contains
cboTestNo.
txtresult
Based on testsDetails tbl
The textbox txtresult is text datatype .
There is a condition
Where
If user select 4 and 5 and 9 together by cboTestNo, for same person (that is in the MainForm). The total of that values in the txtresult must be 100 , if not 100 alert user to check the numbers in that field to make them equals 100 .
Note : user may be insert values additionally to that person ( that is in the MainForm).by the cboTestNo, but the important here is the numbers 4,5 and 9, otherwise not.
An example:
And if user select 4, 5 only , alert user it is necessary to select 9 .
I have a continuous subform contains
cboTestNo.
txtresult
Based on testsDetails tbl
The textbox txtresult is text datatype .
There is a condition
Where
If user select 4 and 5 and 9 together by cboTestNo, for same person (that is in the MainForm). The total of that values in the txtresult must be 100 , if not 100 alert user to check the numbers in that field to make them equals 100 .
Note : user may be insert values additionally to that person ( that is in the MainForm).by the cboTestNo, but the important here is the numbers 4,5 and 9, otherwise not.
An example:
cboTestNo | txtResult |
1 | dr56 |
2 | 67 |
4 | 43.56 |
5 | 22.7 |
9 | 78.2 |