February 7, 200223 yr Morning, I'm trying to reference the value of a pop-up menu in an If or Case statement. When I'm doing it though I'm being told there is no field! If my pop-up window is named "popup" and the value in the pop-up window chosen is "first," how can I write a statement saying "if popup equals first, then 15, otherwise 200." Thanks!!! Ben
February 7, 200223 yr You really have 2 problems here. One is an issue with how value lists work and a second with how boolean logic works. Basically you need to have 2 fields to make this happen. One field is set to use the value list and allows the user to choose an item from the list. The second field is a calculation which converts the item chosen from the value list into something else. For example: PopupChoice is a text field formatted as a Popup List using the value list "Popup". PopupValue is a calculation (number) defined as follows: code: case ( PopupChoice = "First", 15, PopupChoice = "Second", 55, PopupChoice = "Third", 125, 2000 )
Create an account or sign in to comment