Flag Field in Form (Access 2003)

[sharonm]

Hello,

I have an Access 2003 Form for Vendors. I have one field (DBA) which is the
d/b/a name of a Vendor and I have another field (legalname) for this same
vendor.

I have a third field with its control source property set to:

=IIf([Forms]![DBA]<>[Forms]![legalname],"DOES NOT MATCH","OK")

The idea is to have this field display either "Does Not Match" or "OK"
whenever 1 of the 2 first fields are changed. How do I automatically update
this third field whenever a user changes one of the 2 fields?

Thanks.

 

[RonaldoOneNil]

This 3rd field will update automatically anyway because its control source is
a formula.