comment in a text box dependant on the value of another text box

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

Guest

i have created a stock control system and would like to know how do i desplay
a status dependant on another text box value for instance if the text box the
value sits in is "-1" the other text box must display "please order" i can
get all the values correct wich is only two values -1 and 0 if the value is
-1 the other text box must display "please order" and if the value displays 0
the text box must display "stock level OK" the coding is for access 2.0
 
In the second text box , type the following into the control source

=IIF([TextBox1] = 0, "Stock Level OK", "Please Order")
 
Set the control source property of your status box to the following

=iif([OtherTextBox]="-1","Please Order","Stock Level OK")
 
Back
Top