Comparing two fields and output results

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
..
 
R

Roger Carlson

You can do this with an Immediate If statement (IIF)

In the Control Source of Textbox3 put the following:

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Compare two fields and display amount or message..... 8
Comparing two fields and output message 1
WHat IIF need a little more Please? 5
Textbox1.Value Question 2
Validations with messages in userform 0
Comparing text and number fields 4
comparing two arrays 10
recalcuate text boxes (PART 2) NEED HELP PLEASE!! 1

Top