need to check fields against each other in a table

[grmman]

I need to write a module to compare fields in a table.
For example I have acct_num and acct_nummi,
I need to check to see if the value in acct_num = acct_nummi and if not i need to update an other field with the with and Y for yes or N for no.

The problem is I need this function to be generic because the fields I am check change.
One time thru the table could have 20 col next time it can have 40.

I do know the field I have to update had "Diff" in the name of the field.

I have a form desgin(datasheet view) to display the table and were the user enters in the value into the acct_numi field.


I am not sure if this can be done or not or how to go about doing this. I am not sure if I should try to something on the form or in a modlue after the user saves the form.

Thanks for the help.

 

[grmman]

I forgot one more thing:
The form I am using is created on the fly after the data in imported fromn excel.
SO i guess i cant do the compare on the form b/c the from is recreated each time the data changes.