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?