at the command window (i am using VFP6), if i sql custid,custname,comments into array atemp, i can see that atemp(3) contains the memofield data. i change the rowsourcetype to 5 but still can't transfer the its data to column3 of the grid. column3 contains a editbox already. the memofield contains the given tour itinerary by the provider. i need to transfer this info to the grid column so that the user can edit the itinerary for packaging to inward bound tourists. is there anything else i could try? tksSelect into a cursor instead, then you can access the cursor's memo field directly, since the record pointer in the RowSource cursor moves accordingly as an item is selected in the combobox. e.g.,
SELECT custid, custname, comments, LEFT(comments,100) As combocomments ;
FROM table ;
INTO CURSOR cu_rowsource
Combo.RowSourceType = 6
Combo.RowSource = "cu_rowsource.custid, custname, combocomments"
thisform.Edit1.Value = cu_rowsource.comments
Insanity: Doing the same thing over and over and expecting different results.