With this code I can get closer to what I need. CR_Numb: IIf([SUB_No]>0 And [Action_Complete]=False,[CR_Number],[CR_Numbers]) without using the Dlookup. How can I set up the trigger of:
CR_No & Sub_No format for Sub_No<>0 and Action_Complete=True is CR_Number: Format(([CR_No]+([Sub_No]*0.01)),"Fixed") IF Sub_No=0 and Action_Complete=True else CRNumbers: IIf([SUB_No]=0,Format([CR_No],"#"),Format([Sub_No]*0.01," " & " .00"))