Hi Richard ----
First off, what are your buffer settings for the table open? Secondly, is this a public datasession? Is it possible that you have the file locked or open pessimistically somewhere else in the application?
>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?
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05