Hi All,
I have two forms. One is a Customer Entry Form and another is an Invoice Entry Form. Both are non-modal.
When user is on a particular Invoice record in the Invoice form and sees the customer name misspelled, he can do this:
1. hit the Edit button on the Invoice form (which enables needed controls)
2. have focus on the Customer combobox (RowSource is SQL)
3. go to the Customer entry form
4. go to particular custmer record, hit the Edit button on Customer form
5. corrects the spelling, then hits Save button
6. go back to Invoice form, (since my Activate event does a Refresh the correct
spelling is now reflected)
This is where the error occurs:
When user clicks on the combobox and selects on same customer (now with corrected spelling), Error 1585 - Update Conflict pops up!
Can someone be kind enough to explain WHY??
Some Details:
1. RowSource of cboCustomer
SELECT DESCRIPTOR,CODE FROM CUSTOMER INTO CSRCUSTOMER ORDER BY DESCRIPTOR WHERE NOT DELETED()
2. cboCustomer.ColumnCount = 2
cboCustomer.ColumnWidth = 225,75
cboCustomer.BoundColumn = 2
2. Valid Event of cboCustomer:
= SEEK( This.Value, "Customer", "Code" ) *--> this is where error occurs
WITH THIS.PARENT
.edtAddress = Customer.Address
.txtTerms = Customer.Terms
ENDWITH
3. Both forms have Private Data Session, with Optimistic BufferMode.
HELP!
Any light shed on my problem is highly appreciated.
Dennis