I overwrite the cursor with SELECT-SQL.
It's as following:
1. The record is selected in the grid
2. The optionbutton is pressed
3. The grid.RECORDSOURCE is set to "". (I cannot change a cursor)
4. The record in the table is changed for table.keyval = cursor.Keyval
5. The table is updated
6. The variable is stored (mControl=Cursor.KeyVal
7. The new SELECT SQL is made and
8. The grid gets its Recordsource to "cursor" (and the columns are filled}
9. And finally the Cursor.KeyVal is located for mControl.
Christian Isberner
Software Consultant