>
>SELECT P_productname, O_orddte, O_qty, ;
>Sum_rd_qtyrec, O_unitprice, O_checkmark, O_tmp_qtyrec, ;
>O_tmp_daterec, O_tmp_amt, O_orderid, O_p_productid ;
>from lv_order_by_dte_nrp INTO CURSOR crs_grid readwrite
>
>SELECT crs_grid
>thisform.pf1.p1.g1.RecordSource="crs_grid"
>thisform.pf1.p1.g1.RecordSourceType = 1
>thisform.pf1.p1.g1.column6.ControlSource = "=TRANSFORM(crs_grid.O_checkmark,'Y')"
>
>
>However, I keep getting errors when setting the controlsource for the column. The user will be entering a Y or N into the columns. Why can't I set the controlsource? Is there another way of doing this? The cursor field name is crs_grid.O_checkmark.
Even if you hit the syntax right (I think you need to wrap it as "=(transform(...))"), this would leave you with a function as a recordsource, which then makes the control read-only.
To enable users to actually enter data in it, go with Boris's suggestion.