Comparing two fields and output results

  • Thread starter Thread starter Javes
  • Start date Start date
J

Javes

Hi I have no programming skills....

I would like to know if someone has a code for a field I
want to compare: IF Textbox1 is EQUAL to Textbox2 THAN
Textbox3 will display Textbox1 Total OR IF they are not
equal THAN it will display a message "UNBALANCED"

Please assist and if code is available where do I put it
in the Event on update?

Thanks for all your help in adavnce Javes
..
 
You can do this with an Immediate If statement (IIF)

In the Control Source of Textbox3 put the following:

=IIF(Textbox1=Textbox2, Textbox1, "UNBALANCED")
 
Back
Top