That sounds like you have a ComboBox or a ListBox where you've specified multiple fields and included the alias on more than the just first field.




>Getting this error message: 'field' Phase is not found.
>
>List below in the code I am running the inti event of a form.
>
>In the Debug Window it stops at the Thisform.Refresh Line.
>
>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.Refresh
>
>If anyone have any suggestion on how to fix this error, I would greatly appreicated.
>
>
>
>Thank You In Advance
>
>
>
>
>Winfred Majors