Hi Richard,
Try changing the combo boxes rowsourcetype to SQL other than fields. Combo boxes in a grid is vulnerable to this kind of error.
>I'm using a grid for data entry of order items. This grid contains 2 combo boxes and about 6 text fields.
>I have AllowAddNew set to TRUE and in the DblClick Event I do an
>------------------------------
>APPEND BLANK
>REPLACE vpOrderItems_Order_ID.Status WITH ;
> "Not Complete - Last Modified: "+TTOC(DATETIME())+" "+ THISFORM.User_ID
>------------------------------
>
>Frequently I get an error message that says "Record in use by another" ...even if there is only one person in the system. The Method flaged with the error is the valid clause of the first combo box.
>------------(Line 3)------------
>cSelect = SELECT()
>SELECT vporderitems_order_id
>REPLACE vporderitems_order_id.SUP_ID WITH ;
> VAL(This.List(This.ListItemID,3))
>REPLACE vporderitems_order_id.Report_ID WITH ; VAL(This.List(This.ListItemID,4))
>SELECT(cSelect)
>------------------------------
>
>Anyone have any ideas?
JESS S. BANAGA
Project Leader - SDD division
...shifting from VFP to C#.Net
CHARISMA simply means: "Be more concerned about making others feel good about themselves than you are in making them feel good about you."