From another table though, correct? Not the same table that is displayed in the grid....


>Rowsource of combo box is an sql populated list.
>
>>What is the rowsource of the combobox? How is it created?
>>
>>Just some stuff to rule out. Is multilocks on? Is the cursor buffering mode set to optimistic table?
>No, will try that...
>What does dbf() return on the cursor you create?
>a file with a _ name.
>Cursors usually are stored in the tmpfiles location. What happens if you set multilocks on and set the buffering?
>This is set in my form base class load event.
>THAKNS,
>Mike
>
>>

>>IF SET('MULTILOCKS')<>"ON"
>>	SET MULTILOCKS ON
>>ENDIF
>>CREATE CURSOR mycursor (cfieldname c(30)) && whatever your cursor is
>>? DBF('mycursor') && this points to my tmpfiles location set in config.fpw
>>=CURSORSETPROP("Buffering", 4, "mycursor")  && optimistic table
>>*Now try selecting from the combobox
>>

>>
>>
>>
>>>I have a form that has a grid on it. The record source for the grid is a user-defined cursor.. i.e. created by create cursor command.
>>>I have an add button that appends a blank and moves the cursor to the first column.
>>>The first column has a combo box in it.
>>>
>>>Sometimes the user picks a record and they get the "record in use by another" error.
>>>
>>>How can this be? The form has a private data session, the underlying cursor in the grid is created when the form is initialized. There are no other users...
>>>
>>>How can I trap/remove this spurious error.
>>>
>>>
>>>TIA,
>>>Mike