Validation

  • Thread starter Thread starter David
  • Start date Start date
D

David

Got a little problem with the expression builder
I have got a textbox that looks at a field and returns its value(text52),
and another that the user types data in(emr)
I tried in the expression builder <[text52] and I didn't get a message until
I closed the form. Is there a way to get a message when the user types in an
amount that is less than text52 after they leave the textbox.
I tried to go through code(still learning and reading is part of the
problem) and what I got was ("you must save the field before setting
focus"), which I have figured out how to do yet.
Any help is appreciated
 
David said:
Got a little problem with the expression builder
I have got a textbox that looks at a field and returns its
value(text52), and another that the user types data in(emr)
I tried in the expression builder <[text52] and I didn't get a
message until I closed the form. Is there a way to get a message when
the user types in an amount that is less than text52 after they leave
the textbox.
I tried to go through code(still learning and reading is part of the
problem) and what I got was ("you must save the field before setting
focus"), which I have figured out how to do yet.
Any help is appreciated
Click to expand...

Where are you putting this expression? I'd expect you to be putting it
in the Validation Rule property of the text box [emr], in which case you
shouldn't be able to leave the control with a value in it that doesn't
meet the rule.
 
Back
Top