SET SAFETY OFF SET TALK OFF SELECT Vaccine, Maker, Descrip, ; TRANSFORM(Cost,"$999.99") AS COST, ; Minbulk, Unitsize, Pkgsize, Ndcno, Contract, ; Directship ; FROM VACCBULK INTO TABLE ORDER_FLU_VACCINE ; WHERE SUBSTR(VACCINE,1,3)="FLU" AND EMPTY(directship) SELECT ORDER_FLU_VACCINE thisform.txt_dESCRIPTION.Value = "" thisform.txt_pkGSIZE.Value = "" thisform.txt_cdcno.Value ="" thisform.txt_mAKER.Value = "" thisform.txt_cost.Value = "" thisform.txt_ndcno.Value = "" thisform.text4.Value = "" thisform.RefreshIf anyone have any suggestion on how to fix this error, I would greatly appreicated.