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

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
 
J

JohnFol

In the second text box , type the following into the control source

=IIF([TextBox1] = 0, "Stock Level OK", "Please Order")
 
G

Guest

Set the control source property of your status box to the following

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

fill text box with query value 1
Choose a value from a combo box based on a text box 0
Force users to enter a value in a Text box 1
auto populate text box based on combo box value 1
sum combo box based on other combo box 2
Currenct issue with a text box 1
Can't set the null or "" text box to be a calculable text box 0
Default Value for a Text box field 1

Top