I am comparing values for an Audit. I have retrieve the original record and currently comparing one field just to test out. Everything is working fine until I leave a blank value in the combo box.

For example, I have a combo box for PREFIX NAME. I create a new record with the combo box filled with a valid value. I then edit the record and change the PREFIX NAME to a different value and the UPDATE process is properly updating the Audit table. I can continue to EDIT the record and continue to change the PREFIX NAME and it always works, until I change the PREFIX NAME to a BLANK (the first option in a combo box. The record is updated and it writes to the Audit table properly, but if I try to EDIT the record again and change the PREFIX NAME to anything else, the compare does not find a difference and exists the IF/ElSE Branch.

The compare is basically: PrefixName (from the new record) != PrefixName(from the original record)

Any idea what is occurring?

Thanks for any help you can provide,

Charlie