Conditional Expression

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form containing a calc'd field. On that same form is a txt box
where the user takes that calc'd number and enters it into that txt box
(without getting into specifics, I need to store that calc'd value in a table
and this method works pretty well). However, people do occasionally make
mistakes and I'd like to create a macro that will display a message box when
leaving focus from that txt box if the numbers do not match. I'm having
trouble writing such a conditional expression, if one even exists. If anyone
can assist me I would very much appreciate it.
 
Natalie,

Use the equivalent syntax as this for your macro Condition...
[NameOfTextbox]<>[NameOfCalcControl]

An alternative would be to use a macro to copy the value, so manual
entry is avoided.
 
Back
Top