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"