>Hi All:
> I am trying to populate my list view at run time with the my sql statement. However, when this line of code is executed, I get an error message "Command contains unrecognized phrase\keyword". Can any help me with the problem and tell me what am I doing wrong.
>
>Thanks
>
>.LstSource.RowSource = ; && List view
> "SELECT &gcSelect FROM shSrce WHERE UPPER(fcShipNo)+UPPER (fcItemNo)+UPPER(fcShipSrce)+UPPER(fcSrcItmNo)=upper(ctemp.fShipNo)+UPPER(ctemp.fItemNo) INTO CURSOR csrShSrce ORDER BY KeyFld"

---

Mahmood,
If that's not a typo " && List view " comment would be after "...Order by keyfld"

.LstSource.RowSource = ;
"SELECT "+gcSelect+;
  " FROM shSrce  "+;
  " WHERE UPPER(fcShipNo+fcItemNo+fcShipSrce+fcSrcItmNo) = "+;
  " upper(ctemp.fShipNo+ctemp.fItemNo) "+;
  " INTO CURSOR csrShSrce "+;
  "ORDER BY KeyFld"  && List view

I hope fcShipNo, fcItemNo etc are not variables.
Cetin