Basically I have a project where someone has to choose 1, 2, or 3. When they pick one of those then they have to go to that page to fill something out. When they choose page 2 they have to go to page 2 and fill out some things and they may pick more than one thing. However, as shown below in my formula, if they pick 60 then they have to fill out a box, as with 80 and 90. Here is my formula.



if ({Staffing_Note.Choose_Form}) = "1" then
"CASE STAFFING" & Chr(13) &
replace ({Staffing_Note.Case_Staffing_Value},"&",Chr(13))
&
if "60" in ({Staffing_Note.Case_Staffing}) then
"(High risk due to " & {Staffing_Note.High_Risk_DT_Box} & ")" & Chr(13) &

if "80" in ({Staffing_Note.Case_Staffing}) then
"(Major change: " & {Staffing_Note.CS_Major_Change_Event} & ")" & Chr(13) &

if "90" in ({Staffing_Note.Case_Staffing}) then
"(Other: " & {Staffing_Note.CS_Other} & ")"


What is happening is, if they choose 90 and only 90, it does not show me the data in the CS-Other.


Edited by swatts - 05 Dec 2011 at 6:21am