Assigning values

T

TBird

I have a text box on a form with look up values assigned-"SHIP METH".
The field is for mode of shipment so the look up values are: UPS,
FEDEX, USPS, and Other. If "Other" is selected, I want a window to pop
up instructing the user to define "Other" in a text box below. How do
I do this?
 
A

alan fisher

In the after update property of the text box put the code:

If me.SHIP_METH = "Other" then
Msgbox " Define Other in text box below"
End If

Realize that this will only put up a pop up form telling
the user to define Other and will not actually make the
user do anything other than acknowlege the message box.

-----Original Message-----
I have a text box on a form with look up values assigned- "SHIP METH".
The field is for mode of shipment so the look up values are: UPS,
FEDEX, USPS, and Other. If "Other" is selected, I want a window to pop
up instructing the user to define "Other" in a text box below. How do
I do this?



------------------------------------------------
Click to expand...
 
D

DanK

On Update:
If Me![FieldName] = "Other" then Me![OtherText].Visible = -
1 Else Me![OtherText].Visible = 0.
 
Top