June 26, 200817 yr Hello and thanks in advance for your help. I have a radio button (SaleChoice) with 3 values. I'm trying to find 'Price' determined by which of the radio values are chosen. I'm using this code but I get the error.."This field (FixedPrice etc) not found" Price = Case( SaleChoice = FixedPrice, Price1, SaleChoice = ReverseAuction, Price2, SaleChoice = Purchase, Price3 )
June 26, 200817 yr I'm guessing you want: Case( SaleChoice = "FixedPrice", Price1, SaleChoice = "ReverseAuction", Price2, SaleChoice = "Purchase", Price3 )
Create an account or sign in to comment