I am updating a form and have embeded the following into an unbound field, but when opening the form, the field displays "#Error"
=IIf([chkSDel]="-1",[tbxSlsRate],IIf([chkTMgrDel]="-1",[tbxSlsRate],IIf([from]="Stockton",[tbxStckRate],IIf([from]="Yuma",[tbxYumaRate],[tbxTruckRate]))))
The fields causing the problem are: [tbxSlsRate]; [tbxStckRate]; [tbxYumaRate]; [tbxTruckRate]
These fields are from 4 separate Dlookups in other fields looking at a query (i.e. =DLookUp("[TRKRate]","qryTruckRate")) which display the numbers contained in the fields in the query. In the case of the Dlookup, the field is named "tbxTruckRate"
Here is the contents of the original field (I am converting from embedded numbers to using a table that I can change the rates on the fly:
=IIf([chkSDel]="-1","75.00",IIf([chkTMgrDel]="-1","75.00",IIf([from]="Stockton","135.00",IIf([from]="Yuma","145.00","145.00"))))
any suggestions will be helpful.