I have a form that takes user input (about 20 text boxes) and writes to fields in a table. Form is locked to one record per instance.
I need to compare the user input to values in a table. The table is structured so that each record is relative to one specific field in the table (also one specific textbox on the form) and each record has three fields with values that determine a 'range'.
What I need to do is compare the user input (for each field) to the associated ranges in the table to 'grade' the input. The result will be to color textboxes, labels, etc. on the form based on this grading.
What is the most efficient way to do this?
Should I read the grading into an array and then compare each field (textbox on the form)?
Should I compare one field at a time to one specific record? (seems code intensive and very unforgiving when changes come)
Help. Thanks.
I need to compare the user input to values in a table. The table is structured so that each record is relative to one specific field in the table (also one specific textbox on the form) and each record has three fields with values that determine a 'range'.
What I need to do is compare the user input (for each field) to the associated ranges in the table to 'grade' the input. The result will be to color textboxes, labels, etc. on the form based on this grading.
What is the most efficient way to do this?
Should I read the grading into an array and then compare each field (textbox on the form)?
Should I compare one field at a time to one specific record? (seems code intensive and very unforgiving when changes come)
Help. Thanks.