What I am trying to do is display a message when a calculated field on the form is 0 and another message if it isn't.
I have a form that has a total for a table, an entry box to put in the total of an imported vendor spreadsheet and a calculated field to show the difference, if any.
I am lost as to how to write the code...
What I want to do if basically this:
IIf [Difference] = 0, "Balanced", "Out of Balance".
I have tried to put this statement into the validation rule on the "Difference" field; however, it is not working.
I would much rather get some direction as to how to write the code.
Thanks in advance and sorry for the rambling.
I have a form that has a total for a table, an entry box to put in the total of an imported vendor spreadsheet and a calculated field to show the difference, if any.
I am lost as to how to write the code...
What I want to do if basically this:
IIf [Difference] = 0, "Balanced", "Out of Balance".
I have tried to put this statement into the validation rule on the "Difference" field; however, it is not working.
I would much rather get some direction as to how to write the code.
Thanks in advance and sorry for the rambling.