I have a VFP 8.0 form with a Grid on it that derives it's data from a dynamic Cursor, that is re-created based on value from ComboBox selection, that is used in SQL query.
I have been having problems figuring out how to refresh the Grid with new data from this Cursor, each time the Cursor is re-generated.
I have the following code following my CURSOR statement.
Thisform.grdDrawings.RecordSource = "curDrawings"
Thisform.grdDrawings.colDwgNum.ControlSource = "curDrawings.dh_dwgnum"
Thisform.grdDrawings.colRev.ControlSource = "curDrawings.dh_rev"
....
....
I'm getting an error message: Member colDwgNum unknown. When the ControlSource line executes. Regardless, the grid appears to refresh with new Cursor data after I dismiss Error dialog.
How do I handle a clean, error-free Refresh of the Cursor-sourced grid?
Thanks,
Dbk
Don