How to make a form box = a value according to another entry

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

Guest

When someone enters a number into a box on a form, I want another box to
equal a certain number.
For example: If someone enters a number anywhere from 0-4 in one box, then
the other box will equal 0.
 
The following expression sets the value to one if outside the 0-4 range.
Note that this is a calculated *control* on a form, and is NOT bound to
*field* in the form's underlying RecordSource. If you need to use this value
in a report or other display, create a calculated field in a query using the
same expression, and base the form or report on the query.

=IIf([YourTextbox]>=0 And [YourTextbox]<=4,0,1)

Hope that helps.
Sprinks
 
Back
Top